PREVIEW / etf_30min / 2009-03-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-09.parquet
  size:    206 KB
  rows:    6,946

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
2009-03-09 06:00:00	SPY	ETF	67.74	68.57	67.74	68.25	49140.0
2009-03-09 06:30:00	SPY	ETF	68.25	68.37	68.12	68.17	64760.0
2009-03-09 07:00:00	SPY	ETF	68.17	68.5	67.87	68.48	713340.0
2009-03-09 07:30:00	SPY	ETF	68.46	68.63	68.26	68.29	213422.0
2009-03-09 08:00:00	SPY	ETF	68.31	69.3	67.83	68.16	2907948.0
2009-03-09 08:30:00	SPY	ETF	68.15	68.34	68.04	68.25	1929650.0
2009-03-09 09:00:00	SPY	ETF	68.25	68.29	67.89	67.95	2305525.0
2009-03-09 09:30:00	SPY	ETF	67.95	69.46	67.95	68.95	40463998.0
2009-03-09 10:00:00	SPY	ETF	68.95	70.0	68.9	69.49	31751675.0
2009-03-09 10:30:00	SPY	ETF	69.48	69.68	68.82	68.9	25635545.0
2009-03-09 11:00:00	SPY	ETF	68.9	69.24	68.6	68.9901	21561322.0
2009-03-09 11:30:00	SPY	ETF	69.0	69.24	68.71	68.95	18681432.0
2009-03-09 12:00:00	SPY	ETF	68.94	69.45	68.83	69.13	14482583.0
2009-03-09 12:30:00	SPY	ETF	69.13	69.25	68.65	68.79	15728942.0
2009-03-09 13:00:00	SPY	ETF	68.79	68.791	68.13	68.34	21102163.0
2009-03-09 13:30:00	SPY	ETF	68.34	68.7	68.25	68.48	15705889.0
2009-03-09 14:00:00	SPY	ETF	68.47	68.98	68.33	68.57	25901832.0
2009-03-09 14:30:00	SPY	ETF	68.57	68.95	67.95	68.43	24507826.0
2009-03-09 15:00:00	SPY	ETF	68.43	68.66	67.73	68.05	28313175.0
2009-03-09 15:30:00	SPY	ETF	68.05	68.7	67.78	68.07	44339822.0
2009-03-09 16:00:00	SPY	ETF	68.07	69.75	67.87	67.99	15148868.0
2009-03-09 16:30:00	SPY	ETF	67.99	68.8079	67.87	67.99	2152408.0
2009-03-09 17:00:00	SPY	ETF	67.95	68.01	67.89	68.0	3505646.0
2009-03-09 17:30:00	SPY	ETF	67.96	68.0	67.95	67.96	3825.0
2009-03-09 18:00:00	SPY	ETF	67.98	68.01	67.92	67.95	18882.0
2009-03-09 18:30:00	SPY	ETF	67.93	68.02	67.93	68.01	13938.0
2009-03-09 19:00:00	SPY	ETF	68.01	68.08	68.01	68.02	61381.0
2009-03-09 19:30:00	SPY	ETF	68.03	68.14	68.0	68.14	101325.0
2009-03-09 04:00:00	QQQ	ETF	26.25	26.25	26.2	26.23	300.0
2009-03-09 04:30:00	QQQ	ETF	26.28	26.28	26.28	26.28	100.0
2009-03-09 05:00:00	QQQ	ETF	26.2	26.2	26.01	26.01	1000.0
2009-03-09 05:30:00	QQQ	ETF	26.02	26.11	26.02	26.1	900.0
2009-03-09 06:00:00	QQQ	ETF	26.21	26.21	26.21	26.21	1100.0
2009-03-09 07:00:00	QQQ	ETF	26.15	26.28	26.15	26.27	160050.0
2009-03-09 07:30:00	QQQ	ETF	26.28	26.35	26.19	26.28	143765.0
2009-03-09 08:00:00	QQQ	ETF	26.28	26.4	26.19	26.2	466132.0
2009-03-09 08:30:00	QQQ	ETF	26.2	26.22	26.1	26.16	467916.0
2009-03-09 09:00:00	QQQ	ETF	26.14	26.18	26.03	26.06	981439.0
2009-03-09 09:30:00	QQQ	ETF	26.05	26.68	26.02	26.43	18137376.0
2009-03-09 10:00:00	QQQ	ETF	26.4299	26.81	26.4	26.5301	16990696.0
2009-03-09 10:30:00	QQQ	ETF	26.54	26.62	26.15	26.16	17244099.0
2009-03-09 11:00:00	QQQ	ETF	26.16	26.33	26.11	26.2	13687394.0
2009-03-09 11:30:00	QQQ	ETF	26.2	26.27	26.02	26.11	10284189.0
2009-03-09 12:00:00	QQQ	ETF	26.12	26.29	26.06	26.18	8786384.0
2009-03-09 12:30:00	QQQ	ETF	26.18	26.19	25.98	26.02	6232215.0
2009-03-09 13:00:00	QQQ	ETF	26.02	26.02	25.77	25.84	9548012.0
2009-03-09 13:30:00	QQQ	ETF	25.839	25.95	25.82	25.86	6794437.0
2009-03-09 14:00:00	QQQ	ETF	25.87	26.03	25.8	25.87	13510212.0
2009-03-09 14:30:00	QQQ	ETF	25.88	25.94	25.73	25.82	10886617.0
2009-03-09 15:00:00	QQQ	ETF	25.81	26.13	25.6301	25.74	13931904.0

> showing 50 of 6,946 rows — these rows as CSV

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