PREVIEW / etf_30min / 2010-10-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-06.parquet
  size:    262 KB
  rows:    8,833

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-06 04:00:00	SPY	ETF	116.2	116.31	116.2	116.31	888.0
2010-10-06 04:30:00	SPY	ETF	116.33	116.34	116.32	116.32	1000.0
2010-10-06 05:00:00	SPY	ETF	116.4	116.6	116.38	116.45	2551.0
2010-10-06 05:30:00	SPY	ETF	116.45	116.45	116.37	116.37	400.0
2010-10-06 06:00:00	SPY	ETF	116.43	116.45	116.31	116.35	6000.0
2010-10-06 06:30:00	SPY	ETF	116.31	116.37	116.18	116.23	43400.0
2010-10-06 07:00:00	SPY	ETF	116.23	116.29	116.02	116.09	163025.0
2010-10-06 07:30:00	SPY	ETF	116.1	116.39	116.1	116.39	316950.0
2010-10-06 08:00:00	SPY	ETF	116.39	116.45	115.95	115.99	2010376.0
2010-10-06 08:30:00	SPY	ETF	115.99	116.01	115.78	115.92	1997898.0
2010-10-06 09:00:00	SPY	ETF	115.91	116.1	115.91	116.03	1176935.0
2010-10-06 09:30:00	SPY	ETF	116.02	116.29	115.94	116.14	23736511.0
2010-10-06 10:00:00	SPY	ETF	116.14	116.33	115.93	116.08	11601352.0
2010-10-06 10:30:00	SPY	ETF	116.08	116.17	115.88	116.03	13340313.0
2010-10-06 11:00:00	SPY	ETF	116.03	116.09	115.86	116.085	7682317.0
2010-10-06 11:30:00	SPY	ETF	116.08	116.26	116.07	116.13	9699901.0
2010-10-06 12:00:00	SPY	ETF	116.135	116.22	115.88	115.91	6312664.0
2010-10-06 12:30:00	SPY	ETF	115.91	116.01	115.76	115.82	7256367.0
2010-10-06 13:00:00	SPY	ETF	115.82	116.04	115.56	115.7	8222100.0
2010-10-06 13:30:00	SPY	ETF	115.705	115.84	115.63	115.83	5515130.0
2010-10-06 14:00:00	SPY	ETF	115.84	115.88	115.6238	115.8225	8153375.0
2010-10-06 14:30:00	SPY	ETF	115.83	115.94	115.75	115.88	8820406.0
2010-10-06 15:00:00	SPY	ETF	115.885	115.92	115.69	115.82	7039532.0
2010-10-06 15:30:00	SPY	ETF	115.82	116.05	115.71	116.04	15286915.0
2010-10-06 16:00:00	SPY	ETF	116.04	116.255	115.97	116.05	4402037.0
2010-10-06 16:30:00	SPY	ETF	116.05	116.15	116.05	116.12	376137.0
2010-10-06 17:00:00	SPY	ETF	116.11	116.13	115.89	115.97	137578.0
2010-10-06 17:30:00	SPY	ETF	115.95	115.99	115.95	115.97	10212.0
2010-10-06 18:00:00	SPY	ETF	115.96	116.06	115.96	116.0	75111.0
2010-10-06 18:30:00	SPY	ETF	115.99	115.99	115.93	115.93	16137.0
2010-10-06 19:00:00	SPY	ETF	115.97	116.01	115.93	115.96	14049.0
2010-10-06 19:30:00	SPY	ETF	115.98	115.98	115.93	115.98	12172.0
2010-10-06 04:00:00	QQQ	ETF	49.7	49.7	49.7	49.7	300.0
2010-10-06 04:30:00	QQQ	ETF	49.73	49.73	49.73	49.73	100.0
2010-10-06 05:00:00	QQQ	ETF	49.73	49.73	49.73	49.73	200.0
2010-10-06 06:00:00	QQQ	ETF	49.76	49.76	49.7	49.7	16100.0
2010-10-06 06:30:00	QQQ	ETF	49.68	49.68	49.68	49.68	100.0
2010-10-06 07:00:00	QQQ	ETF	49.7	49.7	49.59	49.6	17715.0
2010-10-06 07:30:00	QQQ	ETF	49.65	49.73	49.65	49.73	28631.0
2010-10-06 08:00:00	QQQ	ETF	49.73	49.75	49.53	49.56	485672.0
2010-10-06 08:30:00	QQQ	ETF	49.57	49.58	49.49	49.54	287313.0
2010-10-06 09:00:00	QQQ	ETF	49.54	49.61	49.53	49.59	528300.0
2010-10-06 09:30:00	QQQ	ETF	49.59	49.71	49.48	49.53	8139840.0
2010-10-06 10:00:00	QQQ	ETF	49.54	49.67	49.24	49.31	6850483.0
2010-10-06 10:30:00	QQQ	ETF	49.32	49.33	49.18	49.28	5355192.0
2010-10-06 11:00:00	QQQ	ETF	49.285	49.3099	49.19	49.3	2487457.0
2010-10-06 11:30:00	QQQ	ETF	49.3	49.46	49.295	49.34	4346318.0
2010-10-06 12:00:00	QQQ	ETF	49.33	49.41	49.17	49.18	3630838.0
2010-10-06 12:30:00	QQQ	ETF	49.19	49.24	49.12	49.15	2749922.0
2010-10-06 13:00:00	QQQ	ETF	49.15	49.15	48.91	48.99	9259168.0

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

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