PREVIEW / etf_30min / 2015-10-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-02.parquet
  size:    392 KB
  rows:    13,235

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-02 04:00:00	SPY	ETF	192.65	193.07	192.65	192.97	11625.0
2015-10-02 04:30:00	SPY	ETF	192.93	193.13	192.85	193.08	4950.0
2015-10-02 05:00:00	SPY	ETF	192.9	193.1	192.9	193.0	3141.0
2015-10-02 05:30:00	SPY	ETF	192.89	193.14	192.86	193.14	8900.0
2015-10-02 06:00:00	SPY	ETF	193.16	193.33	193.09	193.13	27411.0
2015-10-02 06:30:00	SPY	ETF	193.15	193.21	193.04	193.15	8400.0
2015-10-02 07:00:00	SPY	ETF	193.2	193.24	192.99	193.02	111422.0
2015-10-02 07:30:00	SPY	ETF	193.04	193.31	192.99	193.26	185917.0
2015-10-02 08:00:00	SPY	ETF	193.27	193.57	192.42	193.57	600619.0
2015-10-02 08:30:00	SPY	ETF	193.59	193.61	189.92	190.29	7235987.0
2015-10-02 09:00:00	SPY	ETF	190.28	190.3	189.35	189.79	3674095.0
2015-10-02 09:30:00	SPY	ETF	189.77	190.1	189.12	189.79	22369302.0
2015-10-02 10:00:00	SPY	ETF	189.79	190.35	189.17	189.72	14784986.0
2015-10-02 10:30:00	SPY	ETF	189.72	191.0	189.56	190.94	10836997.0
2015-10-02 11:00:00	SPY	ETF	190.93	191.375	190.57	191.04	11674280.0
2015-10-02 11:30:00	SPY	ETF	191.03	191.54	190.82	191.1533	7773861.0
2015-10-02 12:00:00	SPY	ETF	191.15	192.08	191.09	191.96	7944735.0
2015-10-02 12:30:00	SPY	ETF	191.95	192.84	191.9	192.67	16465235.0
2015-10-02 13:00:00	SPY	ETF	192.68	193.41	192.61	192.92	13437590.0
2015-10-02 13:30:00	SPY	ETF	192.92	193.13	192.48	192.71	8145278.0
2015-10-02 14:00:00	SPY	ETF	192.71	193.32	192.605	193.13	7759360.0
2015-10-02 14:30:00	SPY	ETF	193.135	193.35	192.81	192.82	7133172.0
2015-10-02 15:00:00	SPY	ETF	192.81	194.31	192.77	194.3	16328741.0
2015-10-02 15:30:00	SPY	ETF	194.3	194.98	194.2	194.98	24457968.0
2015-10-02 16:00:00	SPY	ETF	194.98	195.16	194.71	194.99	8633768.0
2015-10-02 16:30:00	SPY	ETF	194.99	195.09	194.91	195.05	2475666.0
2015-10-02 17:00:00	SPY	ETF	195.07	195.25	194.98	195.21	262137.0
2015-10-02 17:30:00	SPY	ETF	195.21	195.33	195.15	195.33	780117.0
2015-10-02 18:00:00	SPY	ETF	195.33	195.45	195.2	195.28	184196.0
2015-10-02 18:30:00	SPY	ETF	195.28	195.37	195.2	195.37	38185.0
2015-10-02 19:00:00	SPY	ETF	195.37	195.37	195.31	195.31	21427.0
2015-10-02 19:30:00	SPY	ETF	195.33	195.38	195.25	195.38	52551.0
2015-10-02 20:00:00	SPY	ETF	194.919	194.919	194.919	194.919	100000.0
2015-10-02 04:00:00	QQQ	ETF	102.67	102.74	102.67	102.73	6350.0
2015-10-02 04:30:00	QQQ	ETF	102.68	102.82	102.68	102.82	8050.0
2015-10-02 05:30:00	QQQ	ETF	102.75	102.81	102.75	102.81	600.0
2015-10-02 06:00:00	QQQ	ETF	102.84	102.94	102.79	102.94	4620.0
2015-10-02 06:30:00	QQQ	ETF	102.87	102.87	102.87	102.87	6250.0
2015-10-02 07:00:00	QQQ	ETF	102.89	102.89	102.78	102.82	3700.0
2015-10-02 07:30:00	QQQ	ETF	102.84	102.89	102.81	102.89	22994.0
2015-10-02 08:00:00	QQQ	ETF	102.88	103.02	102.78	102.93	92059.0
2015-10-02 08:30:00	QQQ	ETF	102.77	102.98	100.92	101.22	937252.0
2015-10-02 09:00:00	QQQ	ETF	101.21	101.21	100.63	100.8	804791.0
2015-10-02 09:30:00	QQQ	ETF	100.8	101.1	100.48	100.95	5707570.0
2015-10-02 10:00:00	QQQ	ETF	100.93	101.29	100.52	100.94	5293266.0
2015-10-02 10:30:00	QQQ	ETF	100.95	101.859	100.86	101.83	3786368.0
2015-10-02 11:00:00	QQQ	ETF	101.82	102.11	101.5	101.795	2982321.0
2015-10-02 11:30:00	QQQ	ETF	101.79	102.09	101.615	101.84	2117716.0
2015-10-02 12:00:00	QQQ	ETF	101.85	102.38	101.76	102.31	2233443.0
2015-10-02 12:30:00	QQQ	ETF	102.28	102.88	102.28	102.78	4608406.0

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

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