PREVIEW / etf_30min / 2010-05-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-24.parquet
  size:    264 KB
  rows:    8,817

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-05-24 04:00:00	SPY	ETF	108.51	108.57	108.25	108.3	15336.0
2010-05-24 04:30:00	SPY	ETF	108.35	108.46	108.34	108.34	2350.0
2010-05-24 05:00:00	SPY	ETF	108.45	108.56	108.39	108.43	20700.0
2010-05-24 05:30:00	SPY	ETF	108.41	108.47	108.08	108.16	18300.0
2010-05-24 06:00:00	SPY	ETF	108.1	108.1	107.6	107.63	57498.0
2010-05-24 06:30:00	SPY	ETF	107.6	107.91	107.53	107.71	74256.0
2010-05-24 07:00:00	SPY	ETF	107.78	107.95	107.67	107.89	695282.0
2010-05-24 07:30:00	SPY	ETF	107.9	108.17	107.74	108.0	1402267.0
2010-05-24 08:00:00	SPY	ETF	107.98	108.56	107.73	108.04	1418856.0
2010-05-24 08:30:00	SPY	ETF	108.05	109.26	107.54	108.49	3225448.0
2010-05-24 09:00:00	SPY	ETF	108.48	108.83	108.47	108.52	6048832.0
2010-05-24 09:30:00	SPY	ETF	108.52	109.03	108.17	108.38	41962880.0
2010-05-24 10:00:00	SPY	ETF	108.3819	108.97	108.11	108.89	28409373.0
2010-05-24 10:30:00	SPY	ETF	108.89	109.22	108.7	108.88	25099915.0
2010-05-24 11:00:00	SPY	ETF	108.88	109.07	108.55	108.6617	12908694.0
2010-05-24 11:30:00	SPY	ETF	108.66	109.16	108.57	109.06	10826981.0
2010-05-24 12:00:00	SPY	ETF	109.06	109.39	108.97	109.15	9576994.0
2010-05-24 12:30:00	SPY	ETF	109.15	109.37	108.92	109.27	9221478.0
2010-05-24 13:00:00	SPY	ETF	109.27	109.37	108.92	109.08	9654616.0
2010-05-24 13:30:00	SPY	ETF	109.08	109.19	108.58	108.8	11815519.0
2010-05-24 14:00:00	SPY	ETF	108.8	108.99	108.61	108.8317	14216404.0
2010-05-24 14:30:00	SPY	ETF	108.84	108.97	108.46	108.55	11256112.0
2010-05-24 15:00:00	SPY	ETF	108.55	108.65	108.15	108.39	17989470.0
2010-05-24 15:30:00	SPY	ETF	108.3801	108.69	107.61	107.7201	36445353.0
2010-05-24 16:00:00	SPY	ETF	107.73	109.12	107.46	107.48	12982222.0
2010-05-24 16:30:00	SPY	ETF	107.46	107.46	107.17	107.33	818287.0
2010-05-24 17:00:00	SPY	ETF	107.34	107.39	107.12	107.16	230754.0
2010-05-24 17:30:00	SPY	ETF	107.16	107.21	107.06	107.16	153868.0
2010-05-24 18:00:00	SPY	ETF	107.16	107.7	106.95	106.99	352827.0
2010-05-24 18:30:00	SPY	ETF	106.99	107.15	106.94	107.15	108549.0
2010-05-24 19:00:00	SPY	ETF	107.15	107.16	107.05	107.06	93668.0
2010-05-24 19:30:00	SPY	ETF	107.07	107.07	106.83	106.91	190807.0
2010-05-24 20:00:00	SPY	ETF	106.9	106.9	106.9	106.9	100.0
2010-05-24 04:00:00	QQQ	ETF	44.59	44.59	44.57	44.57	8499.0
2010-05-24 04:30:00	QQQ	ETF	44.53	44.53	44.53	44.53	1500.0
2010-05-24 05:00:00	QQQ	ETF	44.61	44.61	44.53	44.53	1100.0
2010-05-24 05:30:00	QQQ	ETF	44.47	44.47	44.47	44.47	122.0
2010-05-24 06:00:00	QQQ	ETF	44.37	44.37	44.27	44.28	2349.0
2010-05-24 06:30:00	QQQ	ETF	44.26	44.26	44.26	44.26	300.0
2010-05-24 07:00:00	QQQ	ETF	44.36	44.41	44.3	44.4	94564.0
2010-05-24 07:30:00	QQQ	ETF	44.39	44.54	44.32	44.45	156557.0
2010-05-24 08:00:00	QQQ	ETF	44.44	44.54	44.44	44.51	845620.0
2010-05-24 08:30:00	QQQ	ETF	44.51	44.78	44.48	44.78	684903.0
2010-05-24 09:00:00	QQQ	ETF	44.77	44.96	44.77	44.81	2215814.0
2010-05-24 09:30:00	QQQ	ETF	44.81	45.15	44.71	44.8919	18342063.0
2010-05-24 10:00:00	QQQ	ETF	44.9	45.19	44.79	45.15	8883058.0
2010-05-24 10:30:00	QQQ	ETF	45.15	45.28	45.04	45.09	9283495.0
2010-05-24 11:00:00	QQQ	ETF	45.09	45.17	44.96	45.03	3775880.0
2010-05-24 11:30:00	QQQ	ETF	45.03	45.19	44.99	45.13	4028212.0
2010-05-24 12:00:00	QQQ	ETF	45.13	45.27	45.05	45.2401	3660694.0

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

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