PREVIEW / etf_30min / 2010-06-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-28.parquet
  size:    242 KB
  rows:    8,011

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-06-28 04:00:00	SPY	ETF	108.1	108.25	108.1	108.25	3200.0
2010-06-28 04:30:00	SPY	ETF	108.26	108.34	108.26	108.34	500.0
2010-06-28 05:00:00	SPY	ETF	108.36	108.39	108.36	108.36	5500.0
2010-06-28 05:30:00	SPY	ETF	108.27	108.3	108.27	108.3	1210.0
2010-06-28 06:00:00	SPY	ETF	108.39	108.39	108.35	108.35	5700.0
2010-06-28 06:30:00	SPY	ETF	108.21	108.27	108.19	108.19	10200.0
2010-06-28 07:00:00	SPY	ETF	108.19	108.35	108.19	108.33	160550.0
2010-06-28 07:30:00	SPY	ETF	108.34	108.34	108.22	108.26	855615.0
2010-06-28 08:00:00	SPY	ETF	108.26	108.29	107.94	108.03	3527532.0
2010-06-28 08:30:00	SPY	ETF	108.04	108.18	107.72	107.91	2898777.0
2010-06-28 09:00:00	SPY	ETF	107.92	108.07	107.82	108.05	2025283.0
2010-06-28 09:30:00	SPY	ETF	108.03	108.12	107.14	107.35	23508641.0
2010-06-28 10:00:00	SPY	ETF	107.35	107.75	107.25	107.67	19353307.0
2010-06-28 10:30:00	SPY	ETF	107.68	107.97	107.415	107.95	15982280.0
2010-06-28 11:00:00	SPY	ETF	107.95	108.18	107.89	108.14	10873099.0
2010-06-28 11:30:00	SPY	ETF	108.14	108.32	107.98	108.0	8540104.0
2010-06-28 12:00:00	SPY	ETF	107.995	108.15	107.73	107.98	11218991.0
2010-06-28 12:30:00	SPY	ETF	107.98	108.12	107.66	107.94	6631015.0
2010-06-28 13:00:00	SPY	ETF	107.95	107.95	107.53	107.67	6207846.0
2010-06-28 13:30:00	SPY	ETF	107.67	107.9	107.49	107.82	5666383.0
2010-06-28 14:00:00	SPY	ETF	107.83	107.99	107.73	107.7417	5141552.0
2010-06-28 14:30:00	SPY	ETF	107.74	108.07	107.68	108.03	8295417.0
2010-06-28 15:00:00	SPY	ETF	108.0299	108.13	107.6	107.6517	10282361.0
2010-06-28 15:30:00	SPY	ETF	107.65	107.98	107.48	107.48	18491125.0
2010-06-28 16:00:00	SPY	ETF	107.49	108.19	107.46	107.54	5735607.0
2010-06-28 16:30:00	SPY	ETF	107.55	107.57	107.4	107.52	961556.0
2010-06-28 17:00:00	SPY	ETF	107.52	107.59	107.45	107.54	394792.0
2010-06-28 17:30:00	SPY	ETF	107.55	107.57	107.48	107.48	40696.0
2010-06-28 18:00:00	SPY	ETF	107.49	107.59	107.42	107.43	349391.0
2010-06-28 18:30:00	SPY	ETF	107.44	107.51	107.42	107.48	23470.0
2010-06-28 19:00:00	SPY	ETF	107.48	107.56	107.48	107.53	12825.0
2010-06-28 19:30:00	SPY	ETF	107.53	107.68	107.47	107.68	47463.0
2010-06-28 04:00:00	QQQ	ETF	45.32	45.35	45.32	45.35	1400.0
2010-06-28 04:30:00	QQQ	ETF	45.38	45.39	45.38	45.39	300.0
2010-06-28 05:00:00	QQQ	ETF	45.38	45.43	45.38	45.43	17795.0
2010-06-28 06:00:00	QQQ	ETF	45.38	45.43	45.36	45.36	300.0
2010-06-28 06:30:00	QQQ	ETF	45.35	45.35	45.35	45.35	5000.0
2010-06-28 07:00:00	QQQ	ETF	45.36	45.44	45.36	45.41	64476.0
2010-06-28 07:30:00	QQQ	ETF	45.39	45.43	45.39	45.39	54404.0
2010-06-28 08:00:00	QQQ	ETF	45.39	45.4	45.26	45.28	1832053.0
2010-06-28 08:30:00	QQQ	ETF	45.32	45.34	45.14	45.23	1589278.0
2010-06-28 09:00:00	QQQ	ETF	45.22	45.3	45.21	45.29	166671.0
2010-06-28 09:30:00	QQQ	ETF	45.29	45.34	44.94	45.04	11297284.0
2010-06-28 10:00:00	QQQ	ETF	45.04	45.11	44.81	45.09	9434391.0
2010-06-28 10:30:00	QQQ	ETF	45.09	45.33	44.95	45.31	7145203.0
2010-06-28 11:00:00	QQQ	ETF	45.32	45.48	45.315	45.47	4199811.0
2010-06-28 11:30:00	QQQ	ETF	45.47	45.55	45.39	45.4	2682771.0
2010-06-28 12:00:00	QQQ	ETF	45.4	45.42	45.25	45.38	4332198.0
2010-06-28 12:30:00	QQQ	ETF	45.37	45.39	45.21	45.33	2839639.0
2010-06-28 13:00:00	QQQ	ETF	45.33	45.335	45.15	45.2	2030047.0

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

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