PREVIEW / etf_30min / 2010-04-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-13.parquet
  size:    249 KB
  rows:    8,352

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-13 04:00:00	SPY	ETF	119.51	119.51	119.51	119.51	200.0
2010-04-13 04:30:00	SPY	ETF	119.39	119.39	119.39	119.39	930.0
2010-04-13 05:00:00	SPY	ETF	119.36	119.37	119.35	119.37	11000.0
2010-04-13 05:30:00	SPY	ETF	119.32	119.45	119.32	119.45	15986.0
2010-04-13 06:00:00	SPY	ETF	119.49	119.49	119.49	119.49	100.0
2010-04-13 06:30:00	SPY	ETF	119.49	119.53	119.48	119.53	12700.0
2010-04-13 07:00:00	SPY	ETF	119.48	119.48	119.38	119.46	549124.0
2010-04-13 07:30:00	SPY	ETF	119.44	119.48	119.39	119.46	259411.0
2010-04-13 08:00:00	SPY	ETF	119.45	119.67	119.2	119.64	956732.0
2010-04-13 08:30:00	SPY	ETF	119.64	119.74	119.55	119.7	558287.0
2010-04-13 09:00:00	SPY	ETF	119.7	119.7	119.56	119.61	314583.0
2010-04-13 09:30:00	SPY	ETF	119.62	119.73	119.42	119.55	16236528.0
2010-04-13 10:00:00	SPY	ETF	119.55	119.63	119.15	119.18	17797171.0
2010-04-13 10:30:00	SPY	ETF	119.18	119.3	119.0	119.22	13551703.0
2010-04-13 11:00:00	SPY	ETF	119.23	119.34	119.14	119.31	6688626.0
2010-04-13 11:30:00	SPY	ETF	119.305	119.37	119.225	119.31	3534713.0
2010-04-13 12:00:00	SPY	ETF	119.31	119.56	119.24	119.54	6855855.0
2010-04-13 12:30:00	SPY	ETF	119.515	119.61	119.43	119.5799	4881036.0
2010-04-13 13:00:00	SPY	ETF	119.5701	119.66	119.55	119.57	6526027.0
2010-04-13 13:30:00	SPY	ETF	119.57	119.83	119.56	119.79	6646966.0
2010-04-13 14:00:00	SPY	ETF	119.79	119.83	119.66	119.66	5176401.0
2010-04-13 14:30:00	SPY	ETF	119.66	119.83	119.64	119.72	5651423.0
2010-04-13 15:00:00	SPY	ETF	119.72	120.04	119.675	119.97	9292562.0
2010-04-13 15:30:00	SPY	ETF	120.0	120.01	119.81	119.87	12429689.0
2010-04-13 16:00:00	SPY	ETF	119.86	120.25	119.23	120.1	5473366.0
2010-04-13 16:30:00	SPY	ETF	120.07	120.09	119.87	120.03	949092.0
2010-04-13 17:00:00	SPY	ETF	120.04	120.08	120.03	120.05	134451.0
2010-04-13 17:30:00	SPY	ETF	120.07	120.1	120.06	120.06	15193.0
2010-04-13 18:00:00	SPY	ETF	120.06	120.06	120.01	120.02	52505.0
2010-04-13 18:30:00	SPY	ETF	120.02	120.02	119.95	119.96	59391.0
2010-04-13 19:00:00	SPY	ETF	119.97	120.0	119.97	119.99	7876.0
2010-04-13 19:30:00	SPY	ETF	119.98	120.02	119.98	120.02	39615.0
2010-04-13 04:30:00	QQQ	ETF	48.93	48.93	48.93	48.93	200.0
2010-04-13 06:00:00	QQQ	ETF	48.95	48.95	48.95	48.95	4400.0
2010-04-13 07:00:00	QQQ	ETF	48.93	48.94	48.92	48.92	29905.0
2010-04-13 07:30:00	QQQ	ETF	48.92	48.95	48.92	48.94	40795.0
2010-04-13 08:00:00	QQQ	ETF	48.94	49.02	48.94	49.02	153380.0
2010-04-13 08:30:00	QQQ	ETF	49.02	49.04	48.98	49.03	45550.0
2010-04-13 09:00:00	QQQ	ETF	49.03	49.04	49.0	49.01	85983.0
2010-04-13 09:30:00	QQQ	ETF	49.02	49.21	48.97	49.12	6687552.0
2010-04-13 10:00:00	QQQ	ETF	49.12	49.16	48.95	48.96	6875743.0
2010-04-13 10:30:00	QQQ	ETF	48.96	49.035	48.86	48.99	5920742.0
2010-04-13 11:00:00	QQQ	ETF	49.0	49.1	48.98	49.08	3723320.0
2010-04-13 11:30:00	QQQ	ETF	49.0799	49.1	48.934	49.06	2449700.0
2010-04-13 12:00:00	QQQ	ETF	49.06	49.12	49.01	49.09	4124055.0
2010-04-13 12:30:00	QQQ	ETF	49.085	49.17	49.05	49.151	2442939.0
2010-04-13 13:00:00	QQQ	ETF	49.15	49.23	49.15	49.16	3374710.0
2010-04-13 13:30:00	QQQ	ETF	49.17	49.31	49.1	49.3	2458817.0
2010-04-13 14:00:00	QQQ	ETF	49.3	49.305	49.2325	49.26	1869085.0
2010-04-13 14:30:00	QQQ	ETF	49.26	49.3	49.23	49.25	2562889.0

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

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