PREVIEW / etf_30min / 2009-12-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-01.parquet
  size:    241 KB
  rows:    7,984

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-01 04:00:00	SPY	ETF	110.72	110.97	110.7	110.97	8800.0
2009-12-01 04:30:00	SPY	ETF	110.99	110.99	110.79	110.79	1400.0
2009-12-01 05:00:00	SPY	ETF	110.8	110.81	110.8	110.8	700.0
2009-12-01 05:30:00	SPY	ETF	110.89	110.89	110.68	110.68	400.0
2009-12-01 06:00:00	SPY	ETF	110.68	110.72	110.65	110.71	4600.0
2009-12-01 06:30:00	SPY	ETF	110.77	110.9	110.77	110.9	24600.0
2009-12-01 07:00:00	SPY	ETF	110.9	110.97	110.86	110.91	206907.0
2009-12-01 07:30:00	SPY	ETF	110.9	110.92	110.77	110.8	644751.0
2009-12-01 08:00:00	SPY	ETF	110.8	110.93	110.74	110.86	745556.0
2009-12-01 08:30:00	SPY	ETF	110.86	110.9	110.78	110.87	652928.0
2009-12-01 09:00:00	SPY	ETF	110.87	110.92	109.94	110.92	1192990.0
2009-12-01 09:30:00	SPY	ETF	110.92	111.33	110.92	111.13	22226852.0
2009-12-01 10:00:00	SPY	ETF	111.13	111.29	110.73	110.96	23464770.0
2009-12-01 10:30:00	SPY	ETF	110.97	111.16	110.9	111.028	8713201.0
2009-12-01 11:00:00	SPY	ETF	111.025	111.36	111.01	111.26	10705690.0
2009-12-01 11:30:00	SPY	ETF	111.26	111.34	111.19	111.2805	6620412.0
2009-12-01 12:00:00	SPY	ETF	111.29	111.43	111.25	111.2799	7335674.0
2009-12-01 12:30:00	SPY	ETF	111.28	111.36	111.21	111.31	4657577.0
2009-12-01 13:00:00	SPY	ETF	111.31	111.58	111.27	111.51	6318956.0
2009-12-01 13:30:00	SPY	ETF	111.52	111.66	111.51	111.53	6149186.0
2009-12-01 14:00:00	SPY	ETF	111.53	111.58	111.42	111.56	4606796.0
2009-12-01 14:30:00	SPY	ETF	111.56	111.63	111.3	111.39	10287650.0
2009-12-01 15:00:00	SPY	ETF	111.39	111.48	111.25	111.3623	11001066.0
2009-12-01 15:30:00	SPY	ETF	111.365	111.45	111.13	111.25	19070127.0
2009-12-01 16:00:00	SPY	ETF	111.24	111.51	110.94	111.3	6095267.0
2009-12-01 16:30:00	SPY	ETF	111.3	111.3	109.9747	111.29	4175219.0
2009-12-01 17:00:00	SPY	ETF	111.55	111.55	111.25	111.3	123998.0
2009-12-01 17:30:00	SPY	ETF	111.3	111.3	111.24	111.28	22513.0
2009-12-01 18:00:00	SPY	ETF	111.28	111.35	111.27	111.35	13682.0
2009-12-01 18:30:00	SPY	ETF	111.35	111.37	111.26	111.34	31200.0
2009-12-01 19:00:00	SPY	ETF	111.28	111.3	111.21	111.24	28803.0
2009-12-01 19:30:00	SPY	ETF	111.3	111.37	111.3	111.35	7510.0
2009-12-01 04:00:00	QQQ	ETF	43.87	43.87	43.87	43.87	750.0
2009-12-01 04:30:00	QQQ	ETF	43.92	43.92	43.9	43.92	15200.0
2009-12-01 05:00:00	QQQ	ETF	43.92	43.92	43.92	43.92	600.0
2009-12-01 06:00:00	QQQ	ETF	43.91	43.91	43.91	43.91	400.0
2009-12-01 06:30:00	QQQ	ETF	43.92	43.93	43.92	43.93	8300.0
2009-12-01 07:00:00	QQQ	ETF	43.95	43.96	43.94	43.96	4100.0
2009-12-01 07:30:00	QQQ	ETF	43.89	43.93	43.88	43.9	67500.0
2009-12-01 08:00:00	QQQ	ETF	43.9	43.93	43.84	43.91	326804.0
2009-12-01 08:30:00	QQQ	ETF	43.91	43.93	43.88	43.91	70315.0
2009-12-01 09:00:00	QQQ	ETF	43.92	43.93	43.56	43.89	555520.0
2009-12-01 09:30:00	QQQ	ETF	43.88	44.14	43.88	44.1	10973509.0
2009-12-01 10:00:00	QQQ	ETF	44.09	44.16	43.93	44.0	9554771.0
2009-12-01 10:30:00	QQQ	ETF	44.0	44.08	43.99	44.07	4082869.0
2009-12-01 11:00:00	QQQ	ETF	44.08	44.17	44.04	44.1283	6091549.0
2009-12-01 11:30:00	QQQ	ETF	44.12	44.18	44.1	44.1505	4616692.0
2009-12-01 12:00:00	QQQ	ETF	44.16	44.24	44.15	44.19	3520680.0
2009-12-01 12:30:00	QQQ	ETF	44.18	44.22	44.16	44.208	1758769.0
2009-12-01 13:00:00	QQQ	ETF	44.208	44.29	44.18	44.26	3015340.0

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

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