PREVIEW / etf_30min / 2013-08-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-20.parquet
  size:    323 KB
  rows:    10,905

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-08-20 04:00:00	SPY	ETF	164.8	164.81	164.72	164.72	3320.0
2013-08-20 04:30:00	SPY	ETF	164.7	165.0	164.7	164.92	8935.0
2013-08-20 05:00:00	SPY	ETF	164.91	164.92	164.85	164.85	10400.0
2013-08-20 05:30:00	SPY	ETF	164.84	164.86	164.72	164.86	10504.0
2013-08-20 06:00:00	SPY	ETF	164.85	164.91	164.79	164.84	201340.0
2013-08-20 06:30:00	SPY	ETF	164.86	165.12	164.86	164.98	52760.0
2013-08-20 07:00:00	SPY	ETF	165.0	165.32	165.0	165.3	159492.0
2013-08-20 07:30:00	SPY	ETF	165.29	165.43	165.27	165.33	340722.0
2013-08-20 08:00:00	SPY	ETF	165.36	165.5	165.02	165.44	305770.0
2013-08-20 08:30:00	SPY	ETF	165.42	165.44	164.76	165.27	818854.0
2013-08-20 09:00:00	SPY	ETF	165.27	165.29	164.76	165.05	715754.0
2013-08-20 09:30:00	SPY	ETF	165.04	165.15	164.86	165.08	13670779.0
2013-08-20 10:00:00	SPY	ETF	165.08	165.46	165.04	165.35	9456251.0
2013-08-20 10:30:00	SPY	ETF	165.35	165.74	165.3	165.59	7428400.0
2013-08-20 11:00:00	SPY	ETF	165.59	165.79	165.59	165.69	4396850.0
2013-08-20 11:30:00	SPY	ETF	165.7	166.07	165.681	165.99	6057381.0
2013-08-20 12:00:00	SPY	ETF	165.99	166.11	165.96	166.04	4952534.0
2013-08-20 12:30:00	SPY	ETF	166.04	166.08	165.82	166.03	3575065.0
2013-08-20 13:00:00	SPY	ETF	166.03	166.2	165.9	165.94	3120216.0
2013-08-20 13:30:00	SPY	ETF	165.94	166.09	165.9	165.97	3890392.0
2013-08-20 14:00:00	SPY	ETF	165.96	166.07	165.83	166.018	3232849.0
2013-08-20 14:30:00	SPY	ETF	166.0	166.05	165.81	165.89	3597478.0
2013-08-20 15:00:00	SPY	ETF	165.9	166.0399	165.86	166.01	3568521.0
2013-08-20 15:30:00	SPY	ETF	166.01	166.11	165.54	165.58	11176752.0
2013-08-20 16:00:00	SPY	ETF	165.59	165.9902	164.8981	165.57	6536758.0
2013-08-20 16:30:00	SPY	ETF	165.57	165.66	165.57	165.6	218949.0
2013-08-20 17:00:00	SPY	ETF	165.59	165.67	165.59	165.6	69732.0
2013-08-20 17:30:00	SPY	ETF	165.62	165.65	165.6	165.64	21438.0
2013-08-20 18:00:00	SPY	ETF	165.65	165.67	165.58	165.64	36528.0
2013-08-20 18:30:00	SPY	ETF	165.64	165.68	165.59	165.6	4785.0
2013-08-20 19:00:00	SPY	ETF	165.64	165.67	165.6	165.67	1700.0
2013-08-20 19:30:00	SPY	ETF	165.64	165.67	165.63	165.63	15810.0
2013-08-20 04:00:00	QQQ	ETF	75.31	75.33	75.24	75.24	14500.0
2013-08-20 04:30:00	QQQ	ETF	75.26	75.36	75.26	75.34	7500.0
2013-08-20 05:00:00	QQQ	ETF	75.32	75.32	75.32	75.32	1100.0
2013-08-20 05:30:00	QQQ	ETF	75.3	75.3	75.26	75.3	5200.0
2013-08-20 06:00:00	QQQ	ETF	75.32	75.33	75.32	75.33	59000.0
2013-08-20 06:30:00	QQQ	ETF	75.34	75.44	75.34	75.4	18800.0
2013-08-20 07:00:00	QQQ	ETF	75.42	75.54	75.4	75.51	21200.0
2013-08-20 07:30:00	QQQ	ETF	75.51	75.58	75.51	75.56	134311.0
2013-08-20 08:00:00	QQQ	ETF	75.54	75.65	75.52	75.61	79500.0
2013-08-20 08:30:00	QQQ	ETF	75.61	75.62	75.35	75.35	227602.0
2013-08-20 09:00:00	QQQ	ETF	75.58	75.59	75.49	75.49	54277.0
2013-08-20 09:30:00	QQQ	ETF	75.49	75.67	75.43	75.59	2741435.0
2013-08-20 10:00:00	QQQ	ETF	75.58	75.72	75.49	75.6499	1793758.0
2013-08-20 10:30:00	QQQ	ETF	75.64	75.84	75.62	75.73	1548568.0
2013-08-20 11:00:00	QQQ	ETF	75.72	75.83	75.72	75.79	1260799.0
2013-08-20 11:30:00	QQQ	ETF	75.79	75.99	75.79	75.95	1109114.0
2013-08-20 12:00:00	QQQ	ETF	75.945	76.03	75.93	75.95	879746.0
2013-08-20 12:30:00	QQQ	ETF	75.95	75.96	75.82	75.9299	661745.0

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

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