PREVIEW / etf_30min / 2013-01-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-03.parquet
  size:    321 KB
  rows:    10,832

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-03 04:00:00	SPY	ETF	145.65	145.72	145.65	145.7	8555.0
2013-01-03 04:30:00	SPY	ETF	145.62	145.66	145.62	145.66	6100.0
2013-01-03 05:00:00	SPY	ETF	145.63	145.63	145.63	145.63	100.0
2013-01-03 05:30:00	SPY	ETF	145.66	145.73	145.66	145.73	6700.0
2013-01-03 06:00:00	SPY	ETF	145.67	145.67	145.67	145.67	1200.0
2013-01-03 06:30:00	SPY	ETF	145.65	145.7	145.59	145.59	28950.0
2013-01-03 07:00:00	SPY	ETF	145.62	145.65	145.58	145.63	117391.0
2013-01-03 07:30:00	SPY	ETF	145.64	145.66	145.61	145.65	142658.0
2013-01-03 08:00:00	SPY	ETF	145.65	146.15	145.59	146.01	709856.0
2013-01-03 08:30:00	SPY	ETF	146.01	146.02	145.77	145.9	1717690.0
2013-01-03 09:00:00	SPY	ETF	145.91	146.0	145.84	145.99	693203.0
2013-01-03 09:30:00	SPY	ETF	145.99	145.99	145.61	145.79	15849830.0
2013-01-03 10:00:00	SPY	ETF	145.79	145.99	145.77	145.91	10484376.0
2013-01-03 10:30:00	SPY	ETF	145.91	146.04	145.82	145.89	6452183.0
2013-01-03 11:00:00	SPY	ETF	145.9	146.21	145.88	146.13	7274460.0
2013-01-03 11:30:00	SPY	ETF	146.125	146.28	146.11	146.165	6409921.0
2013-01-03 12:00:00	SPY	ETF	146.16	146.3	146.15	146.24	5559444.0
2013-01-03 12:30:00	SPY	ETF	146.235	146.27	146.07	146.19	4639278.0
2013-01-03 13:00:00	SPY	ETF	146.19	146.29	146.1	146.28	5338939.0
2013-01-03 13:30:00	SPY	ETF	146.282	146.37	146.26	146.3	4849427.0
2013-01-03 14:00:00	SPY	ETF	146.3	146.31	145.72	145.82	18217133.0
2013-01-03 14:30:00	SPY	ETF	145.82	145.93	145.62	145.85	9704295.0
2013-01-03 15:00:00	SPY	ETF	145.85	145.9	145.46	145.56	12047501.0
2013-01-03 15:30:00	SPY	ETF	145.55	145.79	145.34	145.77	19519376.0
2013-01-03 16:00:00	SPY	ETF	145.77	146.12	145.53	145.67	7283714.0
2013-01-03 16:30:00	SPY	ETF	145.67	145.8783	145.6198	145.76	958826.0
2013-01-03 17:00:00	SPY	ETF	145.77	145.84	145.73	145.74	3066832.0
2013-01-03 17:30:00	SPY	ETF	145.73	145.76	145.7	145.72	16632.0
2013-01-03 18:00:00	SPY	ETF	145.73	145.77	145.71	145.75	20244.0
2013-01-03 18:30:00	SPY	ETF	145.75	145.76	145.62	145.62	28055.0
2013-01-03 19:00:00	SPY	ETF	145.66	145.68	145.61	145.63	8018.0
2013-01-03 19:30:00	SPY	ETF	145.69	145.85	145.69	145.78	34480.0
2013-01-03 04:30:00	QQQ	ETF	67.1	67.1	67.1	67.1	200.0
2013-01-03 05:30:00	QQQ	ETF	67.11	67.11	67.11	67.11	400.0
2013-01-03 06:00:00	QQQ	ETF	67.06	67.06	67.05	67.05	1100.0
2013-01-03 07:00:00	QQQ	ETF	67.02	67.05	67.01	67.04	21400.0
2013-01-03 07:30:00	QQQ	ETF	67.06	67.07	66.98	67.02	53700.0
2013-01-03 08:00:00	QQQ	ETF	67.02	67.18	67.0	67.12	115300.0
2013-01-03 08:30:00	QQQ	ETF	67.12	67.18	67.05	67.13	956946.0
2013-01-03 09:00:00	QQQ	ETF	67.12	67.2	67.1	67.2	174508.0
2013-01-03 09:30:00	QQQ	ETF	67.2	67.22	67.0	67.19	5630153.0
2013-01-03 10:00:00	QQQ	ETF	67.18	67.31	67.14	67.1728	2921561.0
2013-01-03 10:30:00	QQQ	ETF	67.18	67.26	67.1	67.14	1926134.0
2013-01-03 11:00:00	QQQ	ETF	67.13	67.25	67.12	67.2215	1797598.0
2013-01-03 11:30:00	QQQ	ETF	67.225	67.34	67.218	67.239	1873890.0
2013-01-03 12:00:00	QQQ	ETF	67.23	67.3	67.22	67.27	1151213.0
2013-01-03 12:30:00	QQQ	ETF	67.27	67.29	67.17	67.181	2014933.0
2013-01-03 13:00:00	QQQ	ETF	67.1899	67.23	67.13	67.23	2543306.0
2013-01-03 13:30:00	QQQ	ETF	67.23	67.28	67.21	67.25	1377564.0
2013-01-03 14:00:00	QQQ	ETF	67.24	67.28	66.98	67.02	2977198.0

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

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