PREVIEW / etf_30min / 2009-12-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-03.parquet
  size:    237 KB
  rows:    7,946

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-12-03 04:00:00	SPY	ETF	111.88	111.91	111.88	111.91	300.0
2009-12-03 04:30:00	SPY	ETF	111.97	111.97	111.97	111.97	100.0
2009-12-03 05:00:00	SPY	ETF	111.9	111.9	111.9	111.9	500.0
2009-12-03 05:30:00	SPY	ETF	111.89	111.89	111.89	111.89	100.0
2009-12-03 06:00:00	SPY	ETF	111.63	111.74	111.63	111.68	14400.0
2009-12-03 06:30:00	SPY	ETF	111.7	111.7	111.55	111.6	2500.0
2009-12-03 07:00:00	SPY	ETF	111.6	111.65	111.55	111.6	60903.0
2009-12-03 07:30:00	SPY	ETF	111.61	111.79	111.58	111.73	573988.0
2009-12-03 08:00:00	SPY	ETF	111.71	111.98	111.63	111.73	3443339.0
2009-12-03 08:30:00	SPY	ETF	111.74	111.92	111.31	111.55	3791507.0
2009-12-03 09:00:00	SPY	ETF	111.56	111.82	111.47	111.54	1670487.0
2009-12-03 09:30:00	SPY	ETF	111.55	112.18	111.44	111.77	21165271.0
2009-12-03 10:00:00	SPY	ETF	111.78	111.78	111.05	111.4099	30212843.0
2009-12-03 10:30:00	SPY	ETF	111.4	111.56	111.03	111.49	15565066.0
2009-12-03 11:00:00	SPY	ETF	111.49	111.58	111.37	111.5	5923748.0
2009-12-03 11:30:00	SPY	ETF	111.5	111.53	111.21	111.375	6799485.0
2009-12-03 12:00:00	SPY	ETF	111.35	111.5	111.28	111.37	5259676.0
2009-12-03 12:30:00	SPY	ETF	111.37	111.49	111.29	111.459	3979007.0
2009-12-03 13:00:00	SPY	ETF	111.45	111.46	111.25	111.4	5930953.0
2009-12-03 13:30:00	SPY	ETF	111.41	111.56	111.38	111.4975	4256632.0
2009-12-03 14:00:00	SPY	ETF	111.49	111.57	111.3	111.31	6364392.0
2009-12-03 14:30:00	SPY	ETF	111.32	111.46	111.15	111.22	5957813.0
2009-12-03 15:00:00	SPY	ETF	111.2117	111.33	111.07	111.09	8276036.0
2009-12-03 15:30:00	SPY	ETF	111.08	111.18	110.29	110.43	29929105.0
2009-12-03 16:00:00	SPY	ETF	110.42	112.1595	110.24	110.27	4727484.0
2009-12-03 16:30:00	SPY	ETF	110.28	111.3523	110.15	110.15	2272787.0
2009-12-03 17:00:00	SPY	ETF	110.17	110.2	110.11	110.18	130459.0
2009-12-03 17:30:00	SPY	ETF	110.2	110.42	110.14	110.19	165702.0
2009-12-03 18:00:00	SPY	ETF	110.2	110.25	110.17	110.21	164652.0
2009-12-03 18:30:00	SPY	ETF	110.21	110.34	110.21	110.33	65063.0
2009-12-03 19:00:00	SPY	ETF	110.3	110.37	110.15	110.25	38326.0
2009-12-03 19:30:00	SPY	ETF	110.24	110.24	110.16	110.2	18482.0
2009-12-03 04:00:00	QQQ	ETF	44.34	44.34	44.34	44.34	200.0
2009-12-03 06:00:00	QQQ	ETF	44.2	44.25	44.2	44.25	400.0
2009-12-03 06:30:00	QQQ	ETF	44.24	44.24	44.21	44.21	42000.0
2009-12-03 07:00:00	QQQ	ETF	44.2	44.2	44.16	44.16	50100.0
2009-12-03 07:30:00	QQQ	ETF	44.17	44.25	44.16	44.2	286294.0
2009-12-03 08:00:00	QQQ	ETF	44.2	44.3	44.16	44.21	3248443.0
2009-12-03 08:30:00	QQQ	ETF	44.17	44.26	44.13	44.18	789293.0
2009-12-03 09:00:00	QQQ	ETF	44.19	44.29	44.18	44.24	773496.0
2009-12-03 09:30:00	QQQ	ETF	44.24	44.5	44.19	44.38	9450831.0
2009-12-03 10:00:00	QQQ	ETF	44.37	44.385	44.13	44.24	13115371.0
2009-12-03 10:30:00	QQQ	ETF	44.235	44.33	44.14	44.32	6266685.0
2009-12-03 11:00:00	QQQ	ETF	44.32	44.34	44.27	44.32	2442466.0
2009-12-03 11:30:00	QQQ	ETF	44.32	44.35	44.2	44.244	2885498.0
2009-12-03 12:00:00	QQQ	ETF	44.24	44.28	44.21	44.23	2274826.0
2009-12-03 12:30:00	QQQ	ETF	44.23	44.3	44.2	44.29	1940697.0
2009-12-03 13:00:00	QQQ	ETF	44.29	44.29	44.2	44.27	1895704.0
2009-12-03 13:30:00	QQQ	ETF	44.27	44.33	44.26	44.31	1699237.0
2009-12-03 14:00:00	QQQ	ETF	44.31	44.34	44.24	44.25	3136781.0

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

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