PREVIEW / etf_30min / 2017-08-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-22.parquet
  size:    432 KB
  rows:    14,675

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
2017-08-22 04:00:00	SPY	ETF	243.51	243.88	243.45	243.45	12961.0
2017-08-22 04:30:00	SPY	ETF	243.47	243.47	243.46	243.47	7800.0
2017-08-22 05:00:00	SPY	ETF	243.55	243.55	243.19	243.19	1750.0
2017-08-22 05:30:00	SPY	ETF	243.25	243.33	243.25	243.33	500.0
2017-08-22 06:00:00	SPY	ETF	243.42	243.45	243.3	243.3	5110.0
2017-08-22 06:30:00	SPY	ETF	243.3	243.35	243.22	243.22	25224.0
2017-08-22 07:00:00	SPY	ETF	243.27	243.55	243.27	243.4	149317.0
2017-08-22 07:30:00	SPY	ETF	243.4	243.56	243.36	243.51	165375.0
2017-08-22 08:00:00	SPY	ETF	243.51	243.76	243.3	243.76	191057.0
2017-08-22 08:30:00	SPY	ETF	243.76	243.86	243.64	243.67	223271.0
2017-08-22 09:00:00	SPY	ETF	243.67	243.7	243.53	243.59	311332.0
2017-08-22 09:30:00	SPY	ETF	243.57	244.47	243.55	244.2601	6957042.0
2017-08-22 10:00:00	SPY	ETF	244.26	244.57	244.26	244.45	4816206.0
2017-08-22 10:30:00	SPY	ETF	244.46	244.64	244.37	244.5941	3435257.0
2017-08-22 11:00:00	SPY	ETF	244.59	244.68	244.44	244.635	2919272.0
2017-08-22 11:30:00	SPY	ETF	244.635	244.93	244.6	244.86	3449793.0
2017-08-22 12:00:00	SPY	ETF	244.86	245.0801	244.84	244.92	4304286.0
2017-08-22 12:30:00	SPY	ETF	244.915	244.98	244.82	244.975	2471413.0
2017-08-22 13:00:00	SPY	ETF	244.98	245.09	244.96	245.03	2375848.0
2017-08-22 13:30:00	SPY	ETF	245.025	245.09	244.91	244.96	1979080.0
2017-08-22 14:00:00	SPY	ETF	244.95	245.27	244.89	245.24	2939519.0
2017-08-22 14:30:00	SPY	ETF	245.23	245.39	245.19	245.295	2805489.0
2017-08-22 15:00:00	SPY	ETF	245.29	245.43	245.255	245.342	3328775.0
2017-08-22 15:30:00	SPY	ETF	245.35	245.62	245.28	245.4	12316548.0
2017-08-22 16:00:00	SPY	ETF	245.39	245.54	245.26	245.5	4561761.0
2017-08-22 16:30:00	SPY	ETF	245.49	245.64	245.48	245.56	253274.0
2017-08-22 17:00:00	SPY	ETF	245.56	245.6	245.44	245.59	609109.0
2017-08-22 17:30:00	SPY	ETF	245.56	245.59	245.54	245.55	18634.0
2017-08-22 18:00:00	SPY	ETF	245.55	245.65	245.51	245.54	46629.0
2017-08-22 18:30:00	SPY	ETF	245.54	245.59	245.47	245.59	30875.0
2017-08-22 19:00:00	SPY	ETF	245.57	245.68	245.47	245.47	50515.0
2017-08-22 19:30:00	SPY	ETF	245.49	245.58	245.48	245.53	25293.0
2017-08-22 04:00:00	QQQ	ETF	141.76	141.76	141.64	141.64	600.0
2017-08-22 04:30:00	QQQ	ETF	141.71	141.76	141.71	141.76	10600.0
2017-08-22 05:00:00	QQQ	ETF	141.63	141.63	141.55	141.55	2400.0
2017-08-22 05:30:00	QQQ	ETF	141.58	141.67	141.58	141.67	2733.0
2017-08-22 06:00:00	QQQ	ETF	141.67	141.7	141.61	141.61	900.0
2017-08-22 06:30:00	QQQ	ETF	141.66	141.7	141.6	141.6	6900.0
2017-08-22 07:00:00	QQQ	ETF	141.6	141.81	141.6	141.75	124450.0
2017-08-22 07:30:00	QQQ	ETF	141.75	141.8	141.69	141.77	48947.0
2017-08-22 08:00:00	QQQ	ETF	141.66	141.97	141.66	141.96	152682.0
2017-08-22 08:30:00	QQQ	ETF	141.97	142.02	141.88	141.91	245771.0
2017-08-22 09:00:00	QQQ	ETF	141.89	141.9	141.8	141.8	127077.0
2017-08-22 09:30:00	QQQ	ETF	141.8	142.5	141.76	142.2951	6177112.0
2017-08-22 10:00:00	QQQ	ETF	142.3	142.6493	142.2953	142.6	2410153.0
2017-08-22 10:30:00	QQQ	ETF	142.61	142.78	142.52	142.7501	1504555.0
2017-08-22 11:00:00	QQQ	ETF	142.75	142.87	142.715	142.86	1266798.0
2017-08-22 11:30:00	QQQ	ETF	142.8601	143.01	142.8399	142.95	1707187.0
2017-08-22 12:00:00	QQQ	ETF	142.95	143.18	142.94	143.0377	1378958.0
2017-08-22 12:30:00	QQQ	ETF	143.035	143.07	142.94	143.03	793769.0

> showing 50 of 14,675 rows — these rows as CSV

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