PREVIEW / etf_30min / 2013-09-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-04.parquet
  size:    322 KB
  rows:    10,830

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-09-04 04:00:00	SPY	ETF	164.34	164.48	164.34	164.45	5600.0
2013-09-04 04:30:00	SPY	ETF	164.41	164.41	164.22	164.35	13100.0
2013-09-04 05:00:00	SPY	ETF	164.36	164.41	164.33	164.33	29600.0
2013-09-04 05:30:00	SPY	ETF	164.34	164.51	164.27	164.29	8700.0
2013-09-04 06:00:00	SPY	ETF	164.27	164.35	164.27	164.35	24500.0
2013-09-04 06:30:00	SPY	ETF	164.38	164.47	164.38	164.44	8025.0
2013-09-04 07:00:00	SPY	ETF	164.47	164.58	164.38	164.49	67040.0
2013-09-04 07:30:00	SPY	ETF	164.48	164.5	164.34	164.4	76209.0
2013-09-04 08:00:00	SPY	ETF	164.46	164.5	164.32	164.37	143229.0
2013-09-04 08:30:00	SPY	ETF	164.38	164.4	164.13	164.28	765890.0
2013-09-04 09:00:00	SPY	ETF	164.3	164.44	164.29	164.42	835574.0
2013-09-04 09:30:00	SPY	ETF	164.43	164.96	164.135	164.85	12065169.0
2013-09-04 10:00:00	SPY	ETF	164.845	165.32	164.84	165.32	9076027.0
2013-09-04 10:30:00	SPY	ETF	165.32	165.38	165.17	165.33	5261342.0
2013-09-04 11:00:00	SPY	ETF	165.33	165.57	165.3	165.49	5873537.0
2013-09-04 11:30:00	SPY	ETF	165.49	165.92	165.48	165.9	7043582.0
2013-09-04 12:00:00	SPY	ETF	165.9001	165.94	165.78	165.825	4045615.0
2013-09-04 12:30:00	SPY	ETF	165.82	165.92	165.78	165.83	3187348.0
2013-09-04 13:00:00	SPY	ETF	165.831	166.03	165.785	165.99	3073045.0
2013-09-04 13:30:00	SPY	ETF	165.99	166.0	165.72	165.77	3438690.0
2013-09-04 14:00:00	SPY	ETF	165.78	165.9	165.68	165.74	4416063.0
2013-09-04 14:30:00	SPY	ETF	165.749	165.94	165.68	165.88	3889838.0
2013-09-04 15:00:00	SPY	ETF	165.88	166.0	165.59	165.75	8878337.0
2013-09-04 15:30:00	SPY	ETF	165.74	165.85	165.54	165.76	13470386.0
2013-09-04 16:00:00	SPY	ETF	165.75	165.98	165.73	165.95	3719577.0
2013-09-04 16:30:00	SPY	ETF	165.96	166.03	165.96	166.02	2776353.0
2013-09-04 17:00:00	SPY	ETF	166.02	166.09	166.01	166.04	110775.0
2013-09-04 17:30:00	SPY	ETF	166.05	166.07	166.04	166.05	10735.0
2013-09-04 18:00:00	SPY	ETF	166.06	166.06	165.78	166.0	109757.0
2013-09-04 18:30:00	SPY	ETF	166.01	166.05	166.01	166.01	9930.0
2013-09-04 19:00:00	SPY	ETF	166.02	166.07	166.02	166.04	21605.0
2013-09-04 19:30:00	SPY	ETF	166.03	166.08	166.01	166.04	26490.0
2013-09-04 04:00:00	QQQ	ETF	75.81	75.89	75.81	75.83	16800.0
2013-09-04 04:30:00	QQQ	ETF	75.81	75.81	75.75	75.81	13000.0
2013-09-04 05:00:00	QQQ	ETF	75.79	75.79	75.79	75.79	1200.0
2013-09-04 05:30:00	QQQ	ETF	75.81	75.83	75.77	75.77	8900.0
2013-09-04 06:00:00	QQQ	ETF	75.75	75.79	75.74	75.79	7700.0
2013-09-04 06:30:00	QQQ	ETF	75.81	75.87	75.81	75.87	5800.0
2013-09-04 07:00:00	QQQ	ETF	75.88	76.0	75.87	75.97	19470.0
2013-09-04 07:30:00	QQQ	ETF	75.96	75.99	75.96	75.96	10675.0
2013-09-04 08:00:00	QQQ	ETF	75.99	75.99	75.91	75.97	38620.0
2013-09-04 08:30:00	QQQ	ETF	75.97	75.99	75.86	75.97	205662.0
2013-09-04 09:00:00	QQQ	ETF	75.99	76.15	75.98	76.15	239002.0
2013-09-04 09:30:00	QQQ	ETF	76.14	76.32	75.93	76.27	3110755.0
2013-09-04 10:00:00	QQQ	ETF	76.28	76.515	76.27	76.5	2575542.0
2013-09-04 10:30:00	QQQ	ETF	76.51	76.54	76.42	76.51	1190216.0
2013-09-04 11:00:00	QQQ	ETF	76.51	76.63	76.49	76.57	1399993.0
2013-09-04 11:30:00	QQQ	ETF	76.58	76.81	76.57	76.78	2022256.0
2013-09-04 12:00:00	QQQ	ETF	76.78	76.79	76.64	76.705	3541795.0
2013-09-04 12:30:00	QQQ	ETF	76.69	76.77	76.68	76.71	1085649.0

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

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