PREVIEW / etf_30min / 2010-04-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-20.parquet
  size:    252 KB
  rows:    8,498

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-04-20 04:00:00	SPY	ETF	120.16	120.16	120.13	120.13	1500.0
2010-04-20 04:30:00	SPY	ETF	120.04	120.04	120.04	120.04	1500.0
2010-04-20 05:00:00	SPY	ETF	119.95	120.05	119.95	120.05	21700.0
2010-04-20 05:30:00	SPY	ETF	120.18	120.23	120.15	120.23	11300.0
2010-04-20 06:00:00	SPY	ETF	120.3	120.53	120.3	120.53	11100.0
2010-04-20 06:30:00	SPY	ETF	120.5	120.7	120.46	120.7	27150.0
2010-04-20 07:00:00	SPY	ETF	120.66	120.79	120.4	120.51	479554.0
2010-04-20 07:30:00	SPY	ETF	120.5	120.58	120.41	120.44	1007056.0
2010-04-20 08:00:00	SPY	ETF	120.44	120.56	119.81	120.5	518242.0
2010-04-20 08:30:00	SPY	ETF	120.51	120.51	120.36	120.43	1013739.0
2010-04-20 09:00:00	SPY	ETF	120.44	120.58	120.4	120.56	1562422.0
2010-04-20 09:30:00	SPY	ETF	120.56	120.69	120.33	120.545	26387954.0
2010-04-20 10:00:00	SPY	ETF	120.54	120.61	120.18	120.27	15104269.0
2010-04-20 10:30:00	SPY	ETF	120.27	120.51	120.17	120.44	12262127.0
2010-04-20 11:00:00	SPY	ETF	120.44	120.64	120.44	120.6	12004943.0
2010-04-20 11:30:00	SPY	ETF	120.6	120.75	120.53	120.72	7788407.0
2010-04-20 12:00:00	SPY	ETF	120.72	120.98	120.7	120.8584	10080152.0
2010-04-20 12:30:00	SPY	ETF	120.86	120.97	120.7	120.77	6399943.0
2010-04-20 13:00:00	SPY	ETF	120.77	120.85	120.72	120.82	4584782.0
2010-04-20 13:30:00	SPY	ETF	120.81	120.84	120.7	120.7383	4491771.0
2010-04-20 14:00:00	SPY	ETF	120.7301	120.84	120.61	120.75	8322315.0
2010-04-20 14:30:00	SPY	ETF	120.75	120.93	120.66	120.9	6165890.0
2010-04-20 15:00:00	SPY	ETF	120.89	120.95	120.68	120.8	8175919.0
2010-04-20 15:30:00	SPY	ETF	120.79	120.88	120.75	120.87	15407968.0
2010-04-20 16:00:00	SPY	ETF	120.87	121.06	119.871	120.99	8558947.0
2010-04-20 16:30:00	SPY	ETF	120.99	121.31	120.95	121.24	5200421.0
2010-04-20 17:00:00	SPY	ETF	121.24	121.24	121.11	121.17	294735.0
2010-04-20 17:30:00	SPY	ETF	121.15	121.17	121.14	121.16	22574.0
2010-04-20 18:00:00	SPY	ETF	121.16	121.19	121.07	121.12	124583.0
2010-04-20 18:30:00	SPY	ETF	121.11	121.17	121.11	121.17	22450.0
2010-04-20 19:00:00	SPY	ETF	121.17	121.2	121.11	121.11	40750.0
2010-04-20 19:30:00	SPY	ETF	121.11	121.15	121.07	121.14	63146.0
2010-04-20 04:00:00	QQQ	ETF	49.6	49.6	49.6	49.6	250.0
2010-04-20 04:30:00	QQQ	ETF	49.63	49.63	49.63	49.63	100.0
2010-04-20 05:00:00	QQQ	ETF	49.63	49.63	49.63	49.63	100.0
2010-04-20 06:00:00	QQQ	ETF	49.68	49.71	49.68	49.71	900.0
2010-04-20 06:30:00	QQQ	ETF	49.75	49.79	49.74	49.78	17000.0
2010-04-20 07:00:00	QQQ	ETF	49.77	49.79	49.72	49.75	84761.0
2010-04-20 07:30:00	QQQ	ETF	49.76	49.78	49.73	49.73	24291.0
2010-04-20 08:00:00	QQQ	ETF	49.73	49.77	49.72	49.73	83530.0
2010-04-20 08:30:00	QQQ	ETF	49.74	49.74	49.69	49.71	148879.0
2010-04-20 09:00:00	QQQ	ETF	49.7	49.78	49.69	49.75	296271.0
2010-04-20 09:30:00	QQQ	ETF	49.755	49.8	49.57	49.63	10028517.0
2010-04-20 10:00:00	QQQ	ETF	49.63	49.66	49.44	49.47	7324109.0
2010-04-20 10:30:00	QQQ	ETF	49.47	49.63	49.43	49.59	5922577.0
2010-04-20 11:00:00	QQQ	ETF	49.59	49.7	49.59	49.68	4828376.0
2010-04-20 11:30:00	QQQ	ETF	49.68	49.74	49.629	49.73	2714215.0
2010-04-20 12:00:00	QQQ	ETF	49.73	49.87	49.71	49.82	3163595.0
2010-04-20 12:30:00	QQQ	ETF	49.82	49.85	49.76	49.7899	3021975.0
2010-04-20 13:00:00	QQQ	ETF	49.79	49.82	49.75	49.8	1205667.0

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

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