PREVIEW / etf_30min / 2014-10-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-23.parquet
  size:    371 KB
  rows:    12,461

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
2014-10-23 04:00:00	SPY	ETF	193.71	194.39	193.71	194.28	44483.0
2014-10-23 04:30:00	SPY	ETF	194.24	194.24	194.04	194.06	20853.0
2014-10-23 05:00:00	SPY	ETF	194.02	194.2	194.0	194.02	21319.0
2014-10-23 05:30:00	SPY	ETF	194.05	194.21	194.05	194.05	24027.0
2014-10-23 06:00:00	SPY	ETF	194.04	194.09	193.8	193.8	60334.0
2014-10-23 06:30:00	SPY	ETF	193.81	193.81	193.49	193.56	188067.0
2014-10-23 07:00:00	SPY	ETF	193.54	194.01	193.54	193.9	292960.0
2014-10-23 07:30:00	SPY	ETF	193.9	194.44	193.89	194.42	624049.0
2014-10-23 08:00:00	SPY	ETF	194.13	194.7	193.09	194.41	1041865.0
2014-10-23 08:30:00	SPY	ETF	194.42	194.68	194.33	194.63	1334621.0
2014-10-23 09:00:00	SPY	ETF	194.6	194.68	194.42	194.63	1244042.0
2014-10-23 09:30:00	SPY	ETF	194.62	194.87	194.26	194.447	15959239.0
2014-10-23 10:00:00	SPY	ETF	194.45	195.29	194.41	194.98	14108365.0
2014-10-23 10:30:00	SPY	ETF	194.99	195.49	194.92	195.46	7892611.0
2014-10-23 11:00:00	SPY	ETF	195.47	195.75	195.31	195.32	9264237.0
2014-10-23 11:30:00	SPY	ETF	195.315	195.5	195.18	195.31	7753047.0
2014-10-23 12:00:00	SPY	ETF	195.31	195.59	194.57	195.57	6812016.0
2014-10-23 12:30:00	SPY	ETF	195.56	195.57	195.1	195.205	4121649.0
2014-10-23 13:00:00	SPY	ETF	195.21	195.5	195.17	195.5	4091184.0
2014-10-23 13:30:00	SPY	ETF	195.499	195.7	195.42	195.56	5598676.0
2014-10-23 14:00:00	SPY	ETF	195.57	196.2	195.57	196.1	9812426.0
2014-10-23 14:30:00	SPY	ETF	196.105	196.13	194.98	195.45	16587232.0
2014-10-23 15:00:00	SPY	ETF	195.455	195.4599	194.82	194.94	18347020.0
2014-10-23 15:30:00	SPY	ETF	194.94	195.5	194.73	194.95	19156002.0
2014-10-23 16:00:00	SPY	ETF	194.95	195.22	194.9133	195.18	6179420.0
2014-10-23 16:30:00	SPY	ETF	195.18	195.24	195.14	195.2	512191.0
2014-10-23 17:00:00	SPY	ETF	195.21	195.26	195.2	195.23	266444.0
2014-10-23 17:30:00	SPY	ETF	195.21	195.23	195.14	195.16	21575.0
2014-10-23 18:00:00	SPY	ETF	195.16	195.28	195.11	195.13	111071.0
2014-10-23 18:30:00	SPY	ETF	195.13	195.13	195.09	195.1	30061.0
2014-10-23 19:00:00	SPY	ETF	195.13	195.14	195.09	195.13	22503.0
2014-10-23 19:30:00	SPY	ETF	195.13	195.26	195.13	195.26	66269.0
2014-10-23 04:00:00	QQQ	ETF	96.69	97.1	96.69	97.06	1266.0
2014-10-23 04:30:00	QQQ	ETF	97.03	97.03	96.99	96.99	1600.0
2014-10-23 05:00:00	QQQ	ETF	97.0	97.0	96.96	97.0	1651.0
2014-10-23 05:30:00	QQQ	ETF	97.04	97.04	96.98	96.98	3700.0
2014-10-23 06:00:00	QQQ	ETF	97.0	97.02	96.89	96.89	9900.0
2014-10-23 06:30:00	QQQ	ETF	96.89	96.89	96.76	96.78	8800.0
2014-10-23 07:00:00	QQQ	ETF	96.85	97.03	96.85	97.0	29708.0
2014-10-23 07:30:00	QQQ	ETF	97.02	97.24	97.0	97.24	91239.0
2014-10-23 08:00:00	QQQ	ETF	97.2	97.4	96.89	97.22	284681.0
2014-10-23 08:30:00	QQQ	ETF	97.22	97.38	97.18	97.33	186617.0
2014-10-23 09:00:00	QQQ	ETF	97.33	97.35	97.22	97.31	130759.0
2014-10-23 09:30:00	QQQ	ETF	97.31	97.5	97.17	97.42	5189790.0
2014-10-23 10:00:00	QQQ	ETF	97.43	97.89	97.409	97.74	4837899.0
2014-10-23 10:30:00	QQQ	ETF	97.75	97.98	97.7	97.95	2852195.0
2014-10-23 11:00:00	QQQ	ETF	97.95	98.05	97.89	97.92	2577061.0
2014-10-23 11:30:00	QQQ	ETF	97.92	98.02	97.84	97.94	1675799.0
2014-10-23 12:00:00	QQQ	ETF	97.93	98.13	97.8944	98.1037	1216955.0
2014-10-23 12:30:00	QQQ	ETF	98.09	98.09	97.86	97.91	1067350.0

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

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