PREVIEW / etf_30min / 2010-10-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-05.parquet
  size:    272 KB
  rows:    9,028

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-10-05 04:00:00	SPY	ETF	114.08	114.25	114.08	114.25	7750.0
2010-10-05 04:30:00	SPY	ETF	114.4	114.41	114.38	114.38	1350.0
2010-10-05 05:00:00	SPY	ETF	114.32	114.32	114.32	114.32	100.0
2010-10-05 05:30:00	SPY	ETF	114.32	114.32	114.29	114.29	11000.0
2010-10-05 06:00:00	SPY	ETF	114.25	114.25	114.25	114.25	300.0
2010-10-05 06:30:00	SPY	ETF	114.23	114.23	114.15	114.16	32500.0
2010-10-05 07:00:00	SPY	ETF	114.2	114.27	114.17	114.19	268965.0
2010-10-05 07:30:00	SPY	ETF	114.18	114.24	114.14	114.16	218467.0
2010-10-05 08:00:00	SPY	ETF	114.5	114.59	114.14	114.55	1285181.0
2010-10-05 08:30:00	SPY	ETF	114.52	114.88	114.51	114.87	1700054.0
2010-10-05 09:00:00	SPY	ETF	114.87	114.93	114.74	114.81	1831478.0
2010-10-05 09:30:00	SPY	ETF	114.8	115.25	114.67	115.2	22767726.0
2010-10-05 10:00:00	SPY	ETF	115.22	115.32	114.68	115.25	29425933.0
2010-10-05 10:30:00	SPY	ETF	115.25	115.61	115.25	115.41	20908401.0
2010-10-05 11:00:00	SPY	ETF	115.4173	115.59	115.41	115.47	11113646.0
2010-10-05 11:30:00	SPY	ETF	115.46	115.93	115.44	115.73	21166327.0
2010-10-05 12:00:00	SPY	ETF	115.73	115.81	115.69	115.74	5517181.0
2010-10-05 12:30:00	SPY	ETF	115.74	115.94	115.72	115.91	6253177.0
2010-10-05 13:00:00	SPY	ETF	115.91	116.1	115.85	115.99	13475831.0
2010-10-05 13:30:00	SPY	ETF	115.99	116.07	115.88	116.0	5893264.0
2010-10-05 14:00:00	SPY	ETF	116.0	116.08	115.95	115.99	8172533.0
2010-10-05 14:30:00	SPY	ETF	116.0	116.15	115.91	116.09	11054685.0
2010-10-05 15:00:00	SPY	ETF	116.1	116.32	116.04	116.29	15093900.0
2010-10-05 15:30:00	SPY	ETF	116.29	116.3	116.02	116.03	28411168.0
2010-10-05 16:00:00	SPY	ETF	116.03	116.185	113.726	115.94	14350049.0
2010-10-05 16:30:00	SPY	ETF	115.94	115.98	113.6894	115.95	1110284.0
2010-10-05 17:00:00	SPY	ETF	115.94	116.0953	115.93	115.96	6548880.0
2010-10-05 17:30:00	SPY	ETF	115.98	115.99	115.91	115.94	198440.0
2010-10-05 18:00:00	SPY	ETF	115.94	116.05	115.93	116.0	275074.0
2010-10-05 18:30:00	SPY	ETF	115.99	116.02	115.99	116.0	16193.0
2010-10-05 19:00:00	SPY	ETF	116.02	116.04	116.01	116.03	7111.0
2010-10-05 19:30:00	SPY	ETF	116.04	116.15	116.03	116.15	26347.0
2010-10-05 04:00:00	QQQ	ETF	48.75	48.8	48.75	48.8	400.0
2010-10-05 05:30:00	QQQ	ETF	48.77	48.77	48.77	48.77	100.0
2010-10-05 06:00:00	QQQ	ETF	48.82	48.82	48.82	48.82	5000.0
2010-10-05 06:30:00	QQQ	ETF	48.73	48.75	48.73	48.75	200.0
2010-10-05 07:00:00	QQQ	ETF	48.76	48.76	48.73	48.73	4330.0
2010-10-05 07:30:00	QQQ	ETF	48.73	48.76	48.72	48.75	148629.0
2010-10-05 08:00:00	QQQ	ETF	48.73	48.93	48.72	48.92	823003.0
2010-10-05 08:30:00	QQQ	ETF	48.91	49.07	48.9	49.06	423162.0
2010-10-05 09:00:00	QQQ	ETF	49.07	49.1	48.99	49.02	645667.0
2010-10-05 09:30:00	QQQ	ETF	49.03	49.36	49.0	49.32	9798365.0
2010-10-05 10:00:00	QQQ	ETF	49.32	49.47	49.2	49.4101	15040649.0
2010-10-05 10:30:00	QQQ	ETF	49.42	49.56	49.41	49.48	7373862.0
2010-10-05 11:00:00	QQQ	ETF	49.48	49.53	49.43	49.45	3101436.0
2010-10-05 11:30:00	QQQ	ETF	49.445	49.645	49.44	49.57	6326387.0
2010-10-05 12:00:00	QQQ	ETF	49.58	49.6	49.53	49.55	2815029.0
2010-10-05 12:30:00	QQQ	ETF	49.55	49.64	49.54	49.61	3622115.0
2010-10-05 13:00:00	QQQ	ETF	49.61	49.7	49.57	49.6	6754101.0
2010-10-05 13:30:00	QQQ	ETF	49.6	49.62	49.52	49.59	2916953.0

> showing 50 of 9,028 rows — these rows as CSV

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