PREVIEW / etf_30min / 2013-01-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-09.parquet
  size:    292 KB
  rows:    10,188

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
2013-01-09 04:00:00	SPY	ETF	145.88	145.88	145.73	145.73	10244.0
2013-01-09 04:30:00	SPY	ETF	145.63	145.63	145.63	145.63	100.0
2013-01-09 05:00:00	SPY	ETF	145.59	145.59	145.56	145.56	200.0
2013-01-09 05:30:00	SPY	ETF	145.69	145.69	145.64	145.66	20100.0
2013-01-09 06:00:00	SPY	ETF	145.59	145.63	145.59	145.63	700.0
2013-01-09 06:30:00	SPY	ETF	145.57	145.64	145.57	145.64	44500.0
2013-01-09 07:00:00	SPY	ETF	145.62	145.75	145.6	145.74	107771.0
2013-01-09 07:30:00	SPY	ETF	145.74	145.87	145.74	145.84	96551.0
2013-01-09 08:00:00	SPY	ETF	145.85	145.87	145.62	145.75	208772.0
2013-01-09 08:30:00	SPY	ETF	145.73	145.9	145.72	145.87	229161.0
2013-01-09 09:00:00	SPY	ETF	145.88	145.96	145.83	145.86	570027.0
2013-01-09 09:30:00	SPY	ETF	145.87	146.2	145.8	146.16	11558793.0
2013-01-09 10:00:00	SPY	ETF	146.15	146.32	146.09	146.26	8082972.0
2013-01-09 10:30:00	SPY	ETF	146.26	146.27	146.0101	146.1181	5690284.0
2013-01-09 11:00:00	SPY	ETF	146.11	146.18	146.03	146.14	4242780.0
2013-01-09 11:30:00	SPY	ETF	146.14	146.23	146.0	146.08	4419717.0
2013-01-09 12:00:00	SPY	ETF	146.08	146.18	146.02	146.0401	3273119.0
2013-01-09 12:30:00	SPY	ETF	146.05	146.095	145.74	145.91	5863177.0
2013-01-09 13:00:00	SPY	ETF	145.9	145.95	145.78	145.91	5148806.0
2013-01-09 13:30:00	SPY	ETF	145.91	146.0	145.86	145.91	4571442.0
2013-01-09 14:00:00	SPY	ETF	145.9099	146.03	145.87	145.939	2986598.0
2013-01-09 14:30:00	SPY	ETF	145.939	145.98	145.7	145.74	4437254.0
2013-01-09 15:00:00	SPY	ETF	145.73	145.88	145.64	145.84	5168161.0
2013-01-09 15:30:00	SPY	ETF	145.84	145.98	145.73	145.95	11490797.0
2013-01-09 16:00:00	SPY	ETF	145.96	146.02	145.7	145.96	7185895.0
2013-01-09 16:30:00	SPY	ETF	145.97	146.0595	145.5653	146.0	2234519.0
2013-01-09 17:00:00	SPY	ETF	145.99	146.06	145.98	146.02	213245.0
2013-01-09 17:30:00	SPY	ETF	146.02	146.07	146.02	146.06	37802.0
2013-01-09 18:00:00	SPY	ETF	146.04	146.05	145.91	145.92	94944.0
2013-01-09 18:30:00	SPY	ETF	145.91	145.95	145.89	145.91	25415.0
2013-01-09 19:00:00	SPY	ETF	145.91	145.96	145.9	145.94	13100.0
2013-01-09 19:30:00	SPY	ETF	145.97	145.97	145.93	145.94	25650.0
2013-01-09 04:00:00	QQQ	ETF	66.6	66.6	66.6	66.6	250.0
2013-01-09 05:00:00	QQQ	ETF	66.58	66.58	66.58	66.58	100.0
2013-01-09 06:30:00	QQQ	ETF	66.56	66.56	66.56	66.56	5000.0
2013-01-09 07:00:00	QQQ	ETF	66.53	66.54	66.53	66.54	2400.0
2013-01-09 08:00:00	QQQ	ETF	66.62	66.62	66.56	66.57	85510.0
2013-01-09 08:30:00	QQQ	ETF	66.57	66.67	66.56	66.66	66595.0
2013-01-09 09:00:00	QQQ	ETF	66.65	66.67	66.58	66.62	63088.0
2013-01-09 09:30:00	QQQ	ETF	66.62	66.8	66.55	66.749	3121791.0
2013-01-09 10:00:00	QQQ	ETF	66.75	66.95	66.67	66.92	1807266.0
2013-01-09 10:30:00	QQQ	ETF	66.91	66.92	66.78	66.87	1486877.0
2013-01-09 11:00:00	QQQ	ETF	66.87	66.92	66.81	66.86	911446.0
2013-01-09 11:30:00	QQQ	ETF	66.86	66.92	66.79	66.81	945022.0
2013-01-09 12:00:00	QQQ	ETF	66.81	66.86	66.79	66.81	995654.0
2013-01-09 12:30:00	QQQ	ETF	66.81	66.84	66.65	66.74	1461225.0
2013-01-09 13:00:00	QQQ	ETF	66.735	66.77	66.68	66.77	701119.0
2013-01-09 13:30:00	QQQ	ETF	66.76	66.85	66.74	66.8021	875310.0
2013-01-09 14:00:00	QQQ	ETF	66.81	66.88	66.77	66.8299	1033181.0
2013-01-09 14:30:00	QQQ	ETF	66.83	66.85	66.7	66.73	1280043.0

> showing 50 of 10,188 rows — these rows as CSV

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