PREVIEW / etf_30min / 2015-01-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-06.parquet
  size:    402 KB
  rows:    13,473

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
2015-01-06 04:00:00	SPY	ETF	201.65	201.79	201.55	201.78	9040.0
2015-01-06 04:30:00	SPY	ETF	201.81	201.81	201.61	201.68	4575.0
2015-01-06 05:00:00	SPY	ETF	201.68	201.73	201.54	201.7	25775.0
2015-01-06 05:30:00	SPY	ETF	201.63	201.69	201.63	201.69	8039.0
2015-01-06 06:00:00	SPY	ETF	201.69	202.25	201.69	202.25	40045.0
2015-01-06 06:30:00	SPY	ETF	202.18	202.6	202.11	202.58	225953.0
2015-01-06 07:00:00	SPY	ETF	202.51	202.55	202.22	202.5	387938.0
2015-01-06 07:30:00	SPY	ETF	202.44	202.49	202.07	202.25	404103.0
2015-01-06 08:00:00	SPY	ETF	201.52	202.51	201.52	202.0	2840290.0
2015-01-06 08:30:00	SPY	ETF	202.0	202.05	201.79	201.87	532308.0
2015-01-06 09:00:00	SPY	ETF	201.87	202.17	201.87	202.12	1440969.0
2015-01-06 09:30:00	SPY	ETF	202.09	202.395	201.72	202.0392	14042819.0
2015-01-06 10:00:00	SPY	ETF	202.0	202.72	201.64	202.55	17118265.0
2015-01-06 10:30:00	SPY	ETF	202.555	202.58	201.275	201.29	11451559.0
2015-01-06 11:00:00	SPY	ETF	201.29	201.3	200.5	200.6364	14854342.0
2015-01-06 11:30:00	SPY	ETF	200.63	200.65	199.8	199.98	15902414.0
2015-01-06 12:00:00	SPY	ETF	199.98	200.02	199.18	199.55	14071414.0
2015-01-06 12:30:00	SPY	ETF	199.55	200.19	199.45	200.11	12372069.0
2015-01-06 13:00:00	SPY	ETF	200.11	200.12	198.855	199.26	13228772.0
2015-01-06 13:30:00	SPY	ETF	199.25	199.87	199.06	199.859	11966986.0
2015-01-06 14:00:00	SPY	ETF	199.85	200.1	199.28	200.06	11570324.0
2015-01-06 14:30:00	SPY	ETF	200.07	200.985	199.93	200.618	17167166.0
2015-01-06 15:00:00	SPY	ETF	200.61	201.355	200.29	201.28	13250900.0
2015-01-06 15:30:00	SPY	ETF	201.285	201.29	199.82	199.82	22275841.0
2015-01-06 16:00:00	SPY	ETF	199.79	200.19	199.5882	199.89	7228517.0
2015-01-06 16:30:00	SPY	ETF	199.9	199.98	199.85	199.87	3031168.0
2015-01-06 17:00:00	SPY	ETF	199.87	199.93	199.84	199.88	92262.0
2015-01-06 17:30:00	SPY	ETF	199.88	199.99	199.85	199.98	45987.0
2015-01-06 18:00:00	SPY	ETF	199.99	200.08	199.92	199.92	123261.0
2015-01-06 18:30:00	SPY	ETF	199.95	200.16	199.95	200.01	50159.0
2015-01-06 19:00:00	SPY	ETF	200.05	200.15	200.05	200.12	19477.0
2015-01-06 19:30:00	SPY	ETF	200.12	200.17	200.12	200.16	12976.0
2015-01-06 06:00:00	QQQ	ETF	101.36	101.47	101.36	101.47	500.0
2015-01-06 06:30:00	QQQ	ETF	101.55	101.59	101.55	101.59	5000.0
2015-01-06 07:00:00	QQQ	ETF	101.7	101.72	101.61	101.62	3100.0
2015-01-06 07:30:00	QQQ	ETF	101.67	101.7	101.58	101.63	77971.0
2015-01-06 08:00:00	QQQ	ETF	101.6	101.72	101.3	101.54	75596.0
2015-01-06 08:30:00	QQQ	ETF	101.52	101.57	101.45	101.49	137882.0
2015-01-06 09:00:00	QQQ	ETF	101.49	101.63	101.49	101.59	157286.0
2015-01-06 09:30:00	QQQ	ETF	101.58	101.75	101.2899	101.33	4549335.0
2015-01-06 10:00:00	QQQ	ETF	101.31	101.74	101.13	101.64	3366710.0
2015-01-06 10:30:00	QQQ	ETF	101.64	101.68	100.96	100.98	2723990.0
2015-01-06 11:00:00	QQQ	ETF	100.981	101.0	100.57	100.68	2945419.0
2015-01-06 11:30:00	QQQ	ETF	100.681	100.6823	100.21	100.341	3318861.0
2015-01-06 12:00:00	QQQ	ETF	100.3499	100.37	99.75	99.975	3641143.0
2015-01-06 12:30:00	QQQ	ETF	99.97	100.5	99.91	100.46	2413529.0
2015-01-06 13:00:00	QQQ	ETF	100.46	100.4663	99.62	99.959	2750476.0
2015-01-06 13:30:00	QQQ	ETF	99.95	100.35	99.85	100.34	2625746.0
2015-01-06 14:00:00	QQQ	ETF	100.33	100.5196	99.955	100.495	2976049.0
2015-01-06 14:30:00	QQQ	ETF	100.485	100.98	100.37	100.76	3994267.0

> showing 50 of 13,473 rows — these rows as CSV

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