PREVIEW / etf_30min / 2010-08-24

all etf 30-min files

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

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-08-24 04:00:00	SPY	ETF	106.8	106.8	106.1	106.32	4400.0
2010-08-24 04:30:00	SPY	ETF	106.17	106.31	106.17	106.22	1600.0
2010-08-24 05:00:00	SPY	ETF	106.27	106.29	106.22	106.25	13000.0
2010-08-24 05:30:00	SPY	ETF	106.32	106.32	106.18	106.18	1600.0
2010-08-24 06:00:00	SPY	ETF	106.2	106.43	106.2	106.33	3900.0
2010-08-24 06:30:00	SPY	ETF	106.3	106.42	106.3	106.33	14900.0
2010-08-24 07:00:00	SPY	ETF	106.34	106.43	106.28	106.36	122483.0
2010-08-24 07:30:00	SPY	ETF	106.36	106.37	105.98	106.01	572033.0
2010-08-24 08:00:00	SPY	ETF	106.01	106.44	105.74	105.77	2061448.0
2010-08-24 08:30:00	SPY	ETF	105.75	105.99	105.73	105.8	2369748.0
2010-08-24 09:00:00	SPY	ETF	105.81	107.13	105.63	105.95	2547057.0
2010-08-24 09:30:00	SPY	ETF	105.95	106.05	105.54	105.69	33588839.0
2010-08-24 10:00:00	SPY	ETF	105.69	105.92	104.97	105.66	38771661.0
2010-08-24 10:30:00	SPY	ETF	105.65	105.9	105.46	105.89	15893479.0
2010-08-24 11:00:00	SPY	ETF	105.88	106.2	105.76	106.06	17133523.0
2010-08-24 11:30:00	SPY	ETF	106.06	106.39	105.9501	106.11	14789567.0
2010-08-24 12:00:00	SPY	ETF	106.1	106.32	105.83	105.88	10428327.0
2010-08-24 12:30:00	SPY	ETF	105.88	106.03	105.83	105.88	7028324.0
2010-08-24 13:00:00	SPY	ETF	105.88	106.17	105.74	106.16	9303261.0
2010-08-24 13:30:00	SPY	ETF	106.16	106.17	105.54	105.611	11268374.0
2010-08-24 14:00:00	SPY	ETF	105.62	105.93	105.55	105.72	13678477.0
2010-08-24 14:30:00	SPY	ETF	105.72	106.0	105.63	105.922	18686818.0
2010-08-24 15:00:00	SPY	ETF	105.96	106.27	105.86	106.11	16257299.0
2010-08-24 15:30:00	SPY	ETF	106.12	106.15	105.48	105.58	39656117.0
2010-08-24 16:00:00	SPY	ETF	105.58	107.1139	105.48	105.57	22131246.0
2010-08-24 16:30:00	SPY	ETF	105.57	105.57	105.36	105.37	1097433.0
2010-08-24 17:00:00	SPY	ETF	105.38	105.46	105.33	105.42	153572.0
2010-08-24 17:30:00	SPY	ETF	105.45	105.51	105.36	105.44	29255.0
2010-08-24 18:00:00	SPY	ETF	105.43	105.54	105.42	105.49	43099.0
2010-08-24 18:30:00	SPY	ETF	105.45	105.51	105.44	105.49	13320.0
2010-08-24 19:00:00	SPY	ETF	105.48	105.48	105.41	105.44	7687.0
2010-08-24 19:30:00	SPY	ETF	105.43	105.78	105.43	105.77	197967.0
2010-08-24 04:00:00	QQQ	ETF	44.25	44.25	44.12	44.2	4319.0
2010-08-24 04:30:00	QQQ	ETF	44.15	44.21	44.15	44.2	300.0
2010-08-24 06:30:00	QQQ	ETF	44.24	44.25	44.2	44.21	1808.0
2010-08-24 07:00:00	QQQ	ETF	44.22	44.26	44.22	44.22	11300.0
2010-08-24 07:30:00	QQQ	ETF	44.21	44.22	44.08	44.09	116259.0
2010-08-24 08:00:00	QQQ	ETF	44.09	44.13	43.92	43.93	1215406.0
2010-08-24 08:30:00	QQQ	ETF	43.92	44.02	43.91	43.98	270635.0
2010-08-24 09:00:00	QQQ	ETF	43.98	44.48	43.87	44.0	824887.0
2010-08-24 09:30:00	QQQ	ETF	44.01	44.01	43.71	43.77	11124021.0
2010-08-24 10:00:00	QQQ	ETF	43.77	43.83	43.465	43.72	13999541.0
2010-08-24 10:30:00	QQQ	ETF	43.72	43.85	43.645	43.84	4440727.0
2010-08-24 11:00:00	QQQ	ETF	43.84	44.0	43.8	43.97	5544303.0
2010-08-24 11:30:00	QQQ	ETF	43.97	44.12	43.93	43.95	4561096.0
2010-08-24 12:00:00	QQQ	ETF	43.95	44.06	43.835	43.841	2740475.0
2010-08-24 12:30:00	QQQ	ETF	43.86	43.92	43.82	43.83	2582979.0
2010-08-24 13:00:00	QQQ	ETF	43.83	43.95	43.77	43.95	2405497.0
2010-08-24 13:30:00	QQQ	ETF	43.95	43.95	43.68	43.72	3002912.0
2010-08-24 14:00:00	QQQ	ETF	43.72	43.81	43.7	43.72	3743402.0

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

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