PREVIEW / etf_30min / 2009-09-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-21.parquet
  size:    226 KB
  rows:    7,594

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-09-21 04:00:00	SPY	ETF	105.92	105.94	105.89	105.94	9470.0
2009-09-21 04:30:00	SPY	ETF	106.07	106.12	105.85	105.85	2950.0
2009-09-21 05:00:00	SPY	ETF	105.85	105.87	105.8	105.8	2642.0
2009-09-21 05:30:00	SPY	ETF	105.79	105.79	105.72	105.75	6600.0
2009-09-21 06:00:00	SPY	ETF	105.82	105.88	105.74	105.74	14500.0
2009-09-21 06:30:00	SPY	ETF	105.78	105.95	105.78	105.91	14900.0
2009-09-21 07:00:00	SPY	ETF	105.9	106.03	105.84	105.91	278871.0
2009-09-21 07:30:00	SPY	ETF	105.9	106.05	105.88	105.88	201811.0
2009-09-21 08:00:00	SPY	ETF	105.9	106.85	105.63	105.8	1419853.0
2009-09-21 08:30:00	SPY	ETF	105.8	106.25	105.69	105.87	1290838.0
2009-09-21 09:00:00	SPY	ETF	105.87	105.89	105.72	105.89	729740.0
2009-09-21 09:30:00	SPY	ETF	105.89	106.25	105.67	105.82	20397849.0
2009-09-21 10:00:00	SPY	ETF	105.8299	107.0	105.66	106.06	15118744.0
2009-09-21 10:30:00	SPY	ETF	106.06	106.12	105.78	106.0475	9537743.0
2009-09-21 11:00:00	SPY	ETF	106.04	106.51	106.01	106.38	9767785.0
2009-09-21 11:30:00	SPY	ETF	106.38	106.61	106.37	106.4683	8572850.0
2009-09-21 12:00:00	SPY	ETF	106.4601	106.5	106.32	106.37	3674587.0
2009-09-21 12:30:00	SPY	ETF	106.37	106.54	106.25	106.31	4238510.0
2009-09-21 13:00:00	SPY	ETF	106.31	106.38	106.18	106.38	4427343.0
2009-09-21 13:30:00	SPY	ETF	106.38	106.47	106.34	106.41	11197061.0
2009-09-21 14:00:00	SPY	ETF	106.41	106.51	106.27	106.34	4647136.0
2009-09-21 14:30:00	SPY	ETF	106.34	106.54	106.31	106.4101	6630970.0
2009-09-21 15:00:00	SPY	ETF	106.42	106.72	106.36	106.58	9586748.0
2009-09-21 15:30:00	SPY	ETF	106.58	106.59	106.19	106.45	16874949.0
2009-09-21 16:00:00	SPY	ETF	106.45	106.8018	106.3	106.46	11790563.0
2009-09-21 16:30:00	SPY	ETF	106.46	106.8017	106.4	106.43	3068502.0
2009-09-21 17:00:00	SPY	ETF	106.41	106.8018	106.41	106.41	6019126.0
2009-09-21 17:30:00	SPY	ETF	106.46	106.48	106.4	106.47	17270.0
2009-09-21 18:00:00	SPY	ETF	106.44	106.44	106.42	106.44	17117.0
2009-09-21 18:30:00	SPY	ETF	106.45	106.45	106.4	106.44	8100.0
2009-09-21 19:00:00	SPY	ETF	106.46	106.48	106.41	106.41	13254.0
2009-09-21 19:30:00	SPY	ETF	106.46	106.61	106.46	106.58	73707.0
2009-09-21 04:00:00	QQQ	ETF	42.13	42.13	42.13	42.13	3588.0
2009-09-21 04:30:00	QQQ	ETF	42.19	42.19	42.19	42.19	200.0
2009-09-21 05:00:00	QQQ	ETF	42.12	42.15	42.12	42.15	50000.0
2009-09-21 05:30:00	QQQ	ETF	42.06	42.07	42.06	42.06	22500.0
2009-09-21 06:00:00	QQQ	ETF	42.14	42.14	42.14	42.14	3000.0
2009-09-21 06:30:00	QQQ	ETF	42.09	42.13	42.09	42.13	700.0
2009-09-21 07:00:00	QQQ	ETF	42.14	42.18	42.14	42.15	81900.0
2009-09-21 07:30:00	QQQ	ETF	42.2	42.21	42.17	42.17	50388.0
2009-09-21 08:00:00	QQQ	ETF	42.18	42.35	42.08	42.13	387522.0
2009-09-21 08:30:00	QQQ	ETF	42.12	42.23	42.1	42.22	2555533.0
2009-09-21 09:00:00	QQQ	ETF	42.21	42.22	42.15	42.22	990216.0
2009-09-21 09:30:00	QQQ	ETF	42.22	42.4	42.2	42.2201	10152126.0
2009-09-21 10:00:00	QQQ	ETF	42.23	42.39	42.16	42.36	8738658.0
2009-09-21 10:30:00	QQQ	ETF	42.36	42.42	42.29	42.39	4583297.0
2009-09-21 11:00:00	QQQ	ETF	42.39	42.62	42.37	42.56	6236399.0
2009-09-21 11:30:00	QQQ	ETF	42.56	42.69	42.56	42.622	4542332.0
2009-09-21 12:00:00	QQQ	ETF	42.63	42.64	42.52	42.57	2411051.0
2009-09-21 12:30:00	QQQ	ETF	42.57	42.63	42.53	42.55	2316767.0

> showing 50 of 7,594 rows — these rows as CSV

> unlock the full archive -- $79 one-time