PREVIEW / etf_30min / 2010-08-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-12.parquet
  size:    255 KB
  rows:    8,575

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-12 04:00:00	SPY	ETF	109.05	109.2	108.68	108.97	19270.0
2010-08-12 04:30:00	SPY	ETF	108.97	108.97	108.9	108.9	3000.0
2010-08-12 05:00:00	SPY	ETF	108.8	109.08	108.76	108.94	42300.0
2010-08-12 05:30:00	SPY	ETF	109.0	109.0	108.67	108.67	1800.0
2010-08-12 06:00:00	SPY	ETF	108.67	108.89	108.67	108.89	5650.0
2010-08-12 06:30:00	SPY	ETF	108.87	109.02	108.85	108.85	36702.0
2010-08-12 07:00:00	SPY	ETF	108.86	109.04	108.83	108.94	158426.0
2010-08-12 07:30:00	SPY	ETF	108.92	108.92	108.56	108.64	428908.0
2010-08-12 08:00:00	SPY	ETF	108.56	108.84	108.37	108.45	1815926.0
2010-08-12 08:30:00	SPY	ETF	108.41	108.44	107.81	108.01	8359875.0
2010-08-12 09:00:00	SPY	ETF	108.01	109.3	107.58	107.63	8167519.0
2010-08-12 09:30:00	SPY	ETF	107.65	108.5	107.6	108.35	40015395.0
2010-08-12 10:00:00	SPY	ETF	108.36	108.72	108.25	108.31	21961415.0
2010-08-12 10:30:00	SPY	ETF	108.3	108.91	108.25	108.74	13933940.0
2010-08-12 11:00:00	SPY	ETF	108.73	108.96	108.48	108.92	14980017.0
2010-08-12 11:30:00	SPY	ETF	108.92	109.0	108.67	108.76	10416893.0
2010-08-12 12:00:00	SPY	ETF	108.76	108.86	108.58	108.73	6260216.0
2010-08-12 12:30:00	SPY	ETF	108.7201	108.9866	108.7	108.93	5858204.0
2010-08-12 13:00:00	SPY	ETF	108.93	109.0	108.66	108.71	8937013.0
2010-08-12 13:30:00	SPY	ETF	108.7075	108.74	108.37	108.43	8474091.0
2010-08-12 14:00:00	SPY	ETF	108.42	108.6	108.36	108.53	7339725.0
2010-08-12 14:30:00	SPY	ETF	108.5399	108.68	108.27	108.58	10799912.0
2010-08-12 15:00:00	SPY	ETF	108.58	109.02	108.57	108.79	17934498.0
2010-08-12 15:30:00	SPY	ETF	108.785	109.01	108.48	108.64	26359853.0
2010-08-12 16:00:00	SPY	ETF	108.65	109.2656	108.2015	108.53	15924405.0
2010-08-12 16:30:00	SPY	ETF	108.51	108.6782	108.46	108.52	754940.0
2010-08-12 17:00:00	SPY	ETF	108.5	108.59	108.48	108.54	85519.0
2010-08-12 17:30:00	SPY	ETF	108.56	109.2685	108.51	108.53	5021383.0
2010-08-12 18:00:00	SPY	ETF	108.53	108.6	108.5	108.53	19238.0
2010-08-12 18:30:00	SPY	ETF	108.53	108.62	108.52	108.62	41244.0
2010-08-12 19:00:00	SPY	ETF	108.63	108.69	108.63	108.65	48350.0
2010-08-12 19:30:00	SPY	ETF	108.63	108.76	108.62	108.7	79130.0
2010-08-12 04:00:00	QQQ	ETF	45.14	45.18	45.14	45.18	300.0
2010-08-12 04:30:00	QQQ	ETF	45.11	45.13	45.11	45.13	4500.0
2010-08-12 05:00:00	QQQ	ETF	45.13	45.13	45.13	45.13	2500.0
2010-08-12 05:30:00	QQQ	ETF	45.1	45.1	45.03	45.03	21900.0
2010-08-12 06:00:00	QQQ	ETF	45.04	45.09	45.04	45.09	10000.0
2010-08-12 06:30:00	QQQ	ETF	45.09	45.11	45.08	45.08	6987.0
2010-08-12 07:00:00	QQQ	ETF	45.07	45.14	45.06	45.12	138699.0
2010-08-12 07:30:00	QQQ	ETF	45.12	45.12	45.01	45.01	120233.0
2010-08-12 08:00:00	QQQ	ETF	45.23	45.23	44.84	44.86	310163.0
2010-08-12 08:30:00	QQQ	ETF	44.87	44.87	44.62	44.69	821536.0
2010-08-12 09:00:00	QQQ	ETF	44.68	44.69	44.54	44.56	1178715.0
2010-08-12 09:30:00	QQQ	ETF	44.56	44.96	44.45	44.9	14445163.0
2010-08-12 10:00:00	QQQ	ETF	44.9	45.08	44.867	44.905	8307706.0
2010-08-12 10:30:00	QQQ	ETF	44.9	45.2	44.87	45.11	5234622.0
2010-08-12 11:00:00	QQQ	ETF	45.105	45.19	45.0	45.17	2803872.0
2010-08-12 11:30:00	QQQ	ETF	45.16	45.21	45.07	45.12	2737478.0
2010-08-12 12:00:00	QQQ	ETF	45.13	45.15	45.02	45.11	2241393.0
2010-08-12 12:30:00	QQQ	ETF	45.12	45.21	45.105	45.19	1429702.0

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

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