PREVIEW / etf_30min / 2010-09-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-08.parquet
  size:    250 KB
  rows:    8,252

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
2010-09-08 04:00:00	SPY	ETF	109.6	109.6	109.4	109.48	12100.0
2010-09-08 04:30:00	SPY	ETF	109.56	109.56	109.47	109.47	2000.0
2010-09-08 05:00:00	SPY	ETF	109.52	109.52	109.25	109.25	2250.0
2010-09-08 05:30:00	SPY	ETF	109.36	109.37	109.36	109.37	3500.0
2010-09-08 06:00:00	SPY	ETF	109.44	109.88	109.4	109.85	51800.0
2010-09-08 06:30:00	SPY	ETF	109.9	110.01	109.88	109.96	23725.0
2010-09-08 07:00:00	SPY	ETF	109.93	110.17	109.88	110.1	108660.0
2010-09-08 07:30:00	SPY	ETF	110.11	110.12	109.93	109.98	601729.0
2010-09-08 08:00:00	SPY	ETF	109.15	110.22	109.15	110.17	1134534.0
2010-09-08 08:30:00	SPY	ETF	110.17	110.17	109.87	109.95	1525647.0
2010-09-08 09:00:00	SPY	ETF	109.94	109.95	109.45	109.86	1000912.0
2010-09-08 09:30:00	SPY	ETF	109.86	110.35	109.81	110.29	17731729.0
2010-09-08 10:00:00	SPY	ETF	110.29	110.56	110.26	110.43	13958430.0
2010-09-08 10:30:00	SPY	ETF	110.42	110.68	110.4	110.518	9089052.0
2010-09-08 11:00:00	SPY	ETF	110.51	110.76	110.51	110.64	7194865.0
2010-09-08 11:30:00	SPY	ETF	110.64	110.67	110.48	110.56	5132002.0
2010-09-08 12:00:00	SPY	ETF	110.57	110.72	110.55	110.7	4906971.0
2010-09-08 12:30:00	SPY	ETF	110.705	110.85	110.63	110.74	6161823.0
2010-09-08 13:00:00	SPY	ETF	110.75	110.77	110.57	110.65	4316095.0
2010-09-08 13:30:00	SPY	ETF	110.655	110.72	110.22	110.35	10638141.0
2010-09-08 14:00:00	SPY	ETF	110.34	110.47	110.1	110.41	13842161.0
2010-09-08 14:30:00	SPY	ETF	110.42	110.64	110.38	110.49	7773669.0
2010-09-08 15:00:00	SPY	ETF	110.5	110.72	110.36	110.37	11744276.0
2010-09-08 15:30:00	SPY	ETF	110.37	110.6	110.2	110.39	19576424.0
2010-09-08 16:00:00	SPY	ETF	110.4	110.655	109.895	110.46	4884218.0
2010-09-08 16:30:00	SPY	ETF	110.46	110.55	110.3807	110.53	5411557.0
2010-09-08 17:00:00	SPY	ETF	110.54	110.74	110.5	110.7	248669.0
2010-09-08 17:30:00	SPY	ETF	110.69	110.71	110.63	110.65	46961.0
2010-09-08 18:00:00	SPY	ETF	110.63	110.63	110.41	110.57	40387.0
2010-09-08 18:30:00	SPY	ETF	110.58	110.6	110.57	110.57	12100.0
2010-09-08 19:00:00	SPY	ETF	110.56	110.62	110.56	110.62	18356.0
2010-09-08 19:30:00	SPY	ETF	110.6	110.68	110.6	110.66	40535.0
2010-09-08 04:30:00	QQQ	ETF	45.67	45.67	45.67	45.67	200.0
2010-09-08 06:30:00	QQQ	ETF	45.89	45.9	45.87	45.87	3000.0
2010-09-08 07:00:00	QQQ	ETF	45.85	45.96	45.85	45.92	10113.0
2010-09-08 07:30:00	QQQ	ETF	45.93	45.93	45.86	45.87	182589.0
2010-09-08 08:00:00	QQQ	ETF	45.88	45.99	45.85	45.94	676747.0
2010-09-08 08:30:00	QQQ	ETF	45.94	45.94	45.83	45.87	400707.0
2010-09-08 09:00:00	QQQ	ETF	45.87	45.88	45.81	45.84	191489.0
2010-09-08 09:30:00	QQQ	ETF	45.84	46.08	45.82	46.04	9295611.0
2010-09-08 10:00:00	QQQ	ETF	46.05	46.19	46.02	46.12	7872002.0
2010-09-08 10:30:00	QQQ	ETF	46.13	46.24	46.1	46.17	4490845.0
2010-09-08 11:00:00	QQQ	ETF	46.16	46.3	46.16	46.28	4511749.0
2010-09-08 11:30:00	QQQ	ETF	46.28	46.3	46.2	46.24	2855021.0
2010-09-08 12:00:00	QQQ	ETF	46.24	46.4	46.23	46.4	3201415.0
2010-09-08 12:30:00	QQQ	ETF	46.39	46.45	46.36	46.39	3105160.0
2010-09-08 13:00:00	QQQ	ETF	46.39	46.3978	46.321	46.35	770300.0
2010-09-08 13:30:00	QQQ	ETF	46.35	46.38	46.19	46.245	5095668.0
2010-09-08 14:00:00	QQQ	ETF	46.24	46.28	46.14	46.25	4682346.0
2010-09-08 14:30:00	QQQ	ETF	46.26	46.35	46.24	46.285	2104760.0

> showing 50 of 8,252 rows — these rows as CSV

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