PREVIEW / etf_30min / 2015-10-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-01.parquet
  size:    379 KB
  rows:    12,731

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-10-01 04:00:00	SPY	ETF	193.43	193.48	193.12	193.12	5299.0
2015-10-01 04:30:00	SPY	ETF	192.88	193.2	192.88	193.1	18700.0
2015-10-01 05:00:00	SPY	ETF	193.16	193.5	192.97	193.25	52898.0
2015-10-01 05:30:00	SPY	ETF	193.17	193.25	193.01	193.01	1500.0
2015-10-01 06:00:00	SPY	ETF	193.08	193.2	192.76	192.82	13283.0
2015-10-01 06:30:00	SPY	ETF	192.83	193.0	192.63	192.9	111642.0
2015-10-01 07:00:00	SPY	ETF	192.98	193.04	192.21	192.28	208289.0
2015-10-01 07:30:00	SPY	ETF	192.22	192.27	191.92	191.93	250258.0
2015-10-01 08:00:00	SPY	ETF	191.92	193.1	191.69	191.93	847158.0
2015-10-01 08:30:00	SPY	ETF	192.0	192.19	191.7	191.89	693274.0
2015-10-01 09:00:00	SPY	ETF	191.88	192.14	191.63	192.07	1024133.0
2015-10-01 09:30:00	SPY	ETF	192.08	192.49	191.06	191.08	15833118.0
2015-10-01 10:00:00	SPY	ETF	191.09	192.01	190.61	191.85	12221888.0
2015-10-01 10:30:00	SPY	ETF	191.86	191.983	190.96	190.98	7826200.0
2015-10-01 11:00:00	SPY	ETF	190.97	191.34	190.73	191.01	7901274.0
2015-10-01 11:30:00	SPY	ETF	191.02	191.29	190.14	190.361	10382486.0
2015-10-01 12:00:00	SPY	ETF	190.37	190.9901	189.82	190.33	10116731.0
2015-10-01 12:30:00	SPY	ETF	190.32	190.61	190.22	190.431	4003975.0
2015-10-01 13:00:00	SPY	ETF	190.43	190.4589	189.96	190.12	5073541.0
2015-10-01 13:30:00	SPY	ETF	190.115	190.9099	190.07	190.87	6538061.0
2015-10-01 14:00:00	SPY	ETF	190.87	191.52	190.68	191.205	7836393.0
2015-10-01 14:30:00	SPY	ETF	191.215	191.83	191.07	191.7	5535941.0
2015-10-01 15:00:00	SPY	ETF	191.72	192.0	191.49	191.6	10227564.0
2015-10-01 15:30:00	SPY	ETF	191.59	192.24	191.12	192.15	16634596.0
2015-10-01 16:00:00	SPY	ETF	192.15	192.49	192.11	192.47	4475377.0
2015-10-01 16:30:00	SPY	ETF	192.47	192.61	192.41	192.52	1742887.0
2015-10-01 17:00:00	SPY	ETF	192.52	192.65	192.52	192.56	146525.0
2015-10-01 17:30:00	SPY	ETF	192.6	192.63	192.13	192.49	258772.0
2015-10-01 18:00:00	SPY	ETF	192.49	192.55	192.43	192.44	267913.0
2015-10-01 18:30:00	SPY	ETF	192.44	192.57	192.41	192.53	45707.0
2015-10-01 19:00:00	SPY	ETF	192.53	192.54	192.43	192.48	81182.0
2015-10-01 19:30:00	SPY	ETF	192.5	192.75	192.35	192.41	192373.0
2015-10-01 04:00:00	QQQ	ETF	103.0	103.04	102.75	102.75	35303.0
2015-10-01 04:30:00	QQQ	ETF	102.79	102.86	102.74	102.74	10200.0
2015-10-01 05:00:00	QQQ	ETF	102.85	102.91	102.77	102.9	2600.0
2015-10-01 05:30:00	QQQ	ETF	102.89	102.89	102.73	102.83	2000.0
2015-10-01 06:00:00	QQQ	ETF	102.67	102.76	102.59	102.59	2950.0
2015-10-01 06:30:00	QQQ	ETF	102.57	102.66	102.49	102.65	36200.0
2015-10-01 07:00:00	QQQ	ETF	102.67	102.67	102.2	102.2	45397.0
2015-10-01 07:30:00	QQQ	ETF	102.19	102.2	102.0	102.03	266248.0
2015-10-01 08:00:00	QQQ	ETF	102.02	102.62	101.84	102.0	256939.0
2015-10-01 08:30:00	QQQ	ETF	102.0	102.12	101.8	101.88	138467.0
2015-10-01 09:00:00	QQQ	ETF	101.88	101.99	101.81	101.93	392513.0
2015-10-01 09:30:00	QQQ	ETF	101.94	102.06	100.9338	100.969	6285775.0
2015-10-01 10:00:00	QQQ	ETF	100.965	101.69	100.71	101.52	4778537.0
2015-10-01 10:30:00	QQQ	ETF	101.53	101.64	101.11	101.11	2193028.0
2015-10-01 11:00:00	QQQ	ETF	101.12	101.43	101.031	101.23	2245430.0
2015-10-01 11:30:00	QQQ	ETF	101.23	101.43	100.81	100.97	2468846.0
2015-10-01 12:00:00	QQQ	ETF	100.97	101.0428	100.59	100.99	2112426.0
2015-10-01 12:30:00	QQQ	ETF	100.99	101.24	100.94	101.06	1026547.0

> showing 50 of 12,731 rows — these rows as CSV

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