PREVIEW / etf_30min / 2010-03-10

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-10.parquet
  size:    248 KB
  rows:    8,280

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-03-10 04:00:00	SPY	ETF	114.55	114.62	114.55	114.61	3100.0
2010-03-10 04:30:00	SPY	ETF	114.58	114.58	114.46	114.5	20200.0
2010-03-10 05:00:00	SPY	ETF	114.44	114.46	114.44	114.46	600.0
2010-03-10 05:30:00	SPY	ETF	114.54	114.54	114.46	114.46	5500.0
2010-03-10 06:30:00	SPY	ETF	114.6	114.65	114.6	114.61	1200.0
2010-03-10 07:00:00	SPY	ETF	114.63	114.69	114.49	114.53	79846.0
2010-03-10 07:30:00	SPY	ETF	114.5	114.55	114.46	114.53	154939.0
2010-03-10 08:00:00	SPY	ETF	114.52	114.65	114.35	114.59	523076.0
2010-03-10 08:30:00	SPY	ETF	114.59	114.6	114.48	114.55	872426.0
2010-03-10 09:00:00	SPY	ETF	114.55	114.58	114.41	114.5	1174601.0
2010-03-10 09:30:00	SPY	ETF	114.51	114.85	114.47	114.76	16805969.0
2010-03-10 10:00:00	SPY	ETF	114.76	115.06	114.75	115.0	13531068.0
2010-03-10 10:30:00	SPY	ETF	115.0	115.21	115.0	115.11	11128651.0
2010-03-10 11:00:00	SPY	ETF	115.1	115.275	115.1	115.16	10001278.0
2010-03-10 11:30:00	SPY	ETF	115.16	115.225	114.92	115.03	12595496.0
2010-03-10 12:00:00	SPY	ETF	115.03	115.1362	114.56	114.56	14957565.0
2010-03-10 12:30:00	SPY	ETF	114.57	114.88	114.41	114.83	12372110.0
2010-03-10 13:00:00	SPY	ETF	114.8318	115.0	114.71	114.839	9772621.0
2010-03-10 13:30:00	SPY	ETF	114.835	114.97	114.73	114.78	5732328.0
2010-03-10 14:00:00	SPY	ETF	114.775	115.17	114.71	115.13	11893891.0
2010-03-10 14:30:00	SPY	ETF	115.13	115.22	114.96	114.98	8797287.0
2010-03-10 15:00:00	SPY	ETF	114.98	115.17	114.79	114.8	11730035.0
2010-03-10 15:30:00	SPY	ETF	114.79	115.1643	114.4748	114.98	25133290.0
2010-03-10 16:00:00	SPY	ETF	114.97	115.2	114.4748	115.02	13527717.0
2010-03-10 16:30:00	SPY	ETF	115.01	115.15	114.99	115.03	1175836.0
2010-03-10 17:00:00	SPY	ETF	115.04	115.04	114.4748	115.0	1302778.0
2010-03-10 17:30:00	SPY	ETF	115.0	115.04	114.4748	115.02	1050395.0
2010-03-10 18:00:00	SPY	ETF	114.99	115.0	114.9	114.92	105145.0
2010-03-10 18:30:00	SPY	ETF	114.92	115.01	114.9	114.95	23200.0
2010-03-10 19:00:00	SPY	ETF	114.94	115.02	114.92	114.95	62988.0
2010-03-10 19:30:00	SPY	ETF	114.95	114.95	114.89	114.91	43700.0
2010-03-10 05:30:00	QQQ	ETF	46.86	46.86	46.86	46.86	10000.0
2010-03-10 07:00:00	QQQ	ETF	46.89	46.9	46.84	46.84	6313.0
2010-03-10 07:30:00	QQQ	ETF	46.82	46.87	46.82	46.86	3900.0
2010-03-10 08:00:00	QQQ	ETF	46.85	46.9	46.82	46.89	243587.0
2010-03-10 08:30:00	QQQ	ETF	46.88	46.88	46.83	46.86	156355.0
2010-03-10 09:00:00	QQQ	ETF	46.85	46.86	46.8	46.8	193712.0
2010-03-10 09:30:00	QQQ	ETF	46.8	46.98	46.8	46.968	12254229.0
2010-03-10 10:00:00	QQQ	ETF	46.96	47.1304	46.96	47.1	9441782.0
2010-03-10 10:30:00	QQQ	ETF	47.1	47.19	47.09	47.16	6518661.0
2010-03-10 11:00:00	QQQ	ETF	47.15	47.22	47.1228	47.18	5354759.0
2010-03-10 11:30:00	QQQ	ETF	47.1765	47.24	46.9875	47.185	8795611.0
2010-03-10 12:00:00	QQQ	ETF	47.185	47.2	46.9875	47.03	8293229.0
2010-03-10 12:30:00	QQQ	ETF	47.03	47.18	47.0	47.16	5730477.0
2010-03-10 13:00:00	QQQ	ETF	47.15	47.225	47.1	47.14	4764867.0
2010-03-10 13:30:00	QQQ	ETF	47.15	47.21	47.1	47.121	3495080.0
2010-03-10 14:00:00	QQQ	ETF	47.1225	47.23	47.09	47.21	3677006.0
2010-03-10 14:30:00	QQQ	ETF	47.21	47.28	47.19	47.2	4216507.0
2010-03-10 15:00:00	QQQ	ETF	47.2	47.27	47.13	47.14	4538431.0
2010-03-10 15:30:00	QQQ	ETF	47.14	47.22	47.09	47.17	9499529.0

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

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