PREVIEW / etf_30min / 2013-12-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-05.parquet
  size:    321 KB
  rows:    10,878

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
2013-12-05 04:00:00	SPY	ETF	179.8	179.8	179.67	179.69	12659.0
2013-12-05 04:30:00	SPY	ETF	179.7	179.8	179.7	179.8	580.0
2013-12-05 05:00:00	SPY	ETF	179.72	179.72	179.66	179.69	1788.0
2013-12-05 05:30:00	SPY	ETF	179.7	179.73	179.65	179.66	5278.0
2013-12-05 06:00:00	SPY	ETF	179.69	179.77	179.69	179.73	3142.0
2013-12-05 06:30:00	SPY	ETF	179.71	179.71	179.61	179.63	52625.0
2013-12-05 07:00:00	SPY	ETF	179.66	179.84	179.66	179.73	93443.0
2013-12-05 07:30:00	SPY	ETF	179.73	179.78	179.7	179.78	69784.0
2013-12-05 08:00:00	SPY	ETF	179.75	179.98	179.75	179.96	211565.0
2013-12-05 08:30:00	SPY	ETF	179.96	179.96	179.46	179.48	1594853.0
2013-12-05 09:00:00	SPY	ETF	179.48	179.58	179.17	179.4	1415463.0
2013-12-05 09:30:00	SPY	ETF	179.41	179.62	179.07	179.365	11461281.0
2013-12-05 10:00:00	SPY	ETF	179.36	179.74	179.12	179.255	8952196.0
2013-12-05 10:30:00	SPY	ETF	179.26	179.43	178.98	179.0901	7409616.0
2013-12-05 11:00:00	SPY	ETF	179.09	179.32	178.91	179.12	6542832.0
2013-12-05 11:30:00	SPY	ETF	179.12	179.3	178.97	179.27	4378148.0
2013-12-05 12:00:00	SPY	ETF	179.27	179.555	179.265	179.42	5115253.0
2013-12-05 12:30:00	SPY	ETF	179.411	179.5099	179.26	179.41	2823043.0
2013-12-05 13:00:00	SPY	ETF	179.41	179.46	179.06	179.15	2631302.0
2013-12-05 13:30:00	SPY	ETF	179.15	179.26	179.04	179.14	4731729.0
2013-12-05 14:00:00	SPY	ETF	179.14	179.34	178.87	179.075	4900844.0
2013-12-05 14:30:00	SPY	ETF	179.07	179.22	178.79	178.87	4079116.0
2013-12-05 15:00:00	SPY	ETF	178.87	179.2299	178.7701	178.99	7801906.0
2013-12-05 15:30:00	SPY	ETF	178.99	179.32	178.82	178.99	18053893.0
2013-12-05 16:00:00	SPY	ETF	178.98	179.3801	178.86	178.97	4719548.0
2013-12-05 16:30:00	SPY	ETF	178.97	179.01	178.9	178.94	2993324.0
2013-12-05 17:00:00	SPY	ETF	178.91	179.01	178.89	179.01	525002.0
2013-12-05 17:30:00	SPY	ETF	179.01	179.02	178.97	179.01	259460.0
2013-12-05 18:00:00	SPY	ETF	179.03	179.14	179.0	179.04	286981.0
2013-12-05 18:30:00	SPY	ETF	179.01	179.04	178.98	179.01	12115.0
2013-12-05 19:00:00	SPY	ETF	179.03	179.1	179.03	179.09	103250.0
2013-12-05 19:30:00	SPY	ETF	179.09	179.17	179.09	179.15	139070.0
2013-12-05 04:00:00	QQQ	ETF	85.6	85.6	85.58	85.58	6400.0
2013-12-05 04:30:00	QQQ	ETF	85.6	85.63	85.6	85.63	2400.0
2013-12-05 05:00:00	QQQ	ETF	85.64	85.64	85.57	85.59	4600.0
2013-12-05 06:00:00	QQQ	ETF	85.6	85.65	85.6	85.65	2700.0
2013-12-05 06:30:00	QQQ	ETF	85.6	85.6	85.57	85.57	4700.0
2013-12-05 07:00:00	QQQ	ETF	85.6	85.68	85.6	85.65	12100.0
2013-12-05 07:30:00	QQQ	ETF	85.63	85.64	85.6	85.61	6848.0
2013-12-05 08:00:00	QQQ	ETF	85.6	85.72	85.6	85.7	52410.0
2013-12-05 08:30:00	QQQ	ETF	85.69	85.69	85.52	85.58	204235.0
2013-12-05 09:00:00	QQQ	ETF	85.54	85.62	85.49	85.57	361722.0
2013-12-05 09:30:00	QQQ	ETF	85.57	85.66	85.34	85.495	4650238.0
2013-12-05 10:00:00	QQQ	ETF	85.51	85.64	85.31	85.36	4996677.0
2013-12-05 10:30:00	QQQ	ETF	85.37	85.58	85.32	85.37	4215492.0
2013-12-05 11:00:00	QQQ	ETF	85.37	85.44	85.26	85.32	2990949.0
2013-12-05 11:30:00	QQQ	ETF	85.32	85.3401	85.2	85.33	1938823.0
2013-12-05 12:00:00	QQQ	ETF	85.33	85.5	85.3201	85.455	1633745.0
2013-12-05 12:30:00	QQQ	ETF	85.46	85.57	85.43	85.5	1570331.0
2013-12-05 13:00:00	QQQ	ETF	85.5	85.52	85.34	85.375	1123174.0

> showing 50 of 10,878 rows — these rows as CSV

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