PREVIEW / etf_30min / 2013-08-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-22.parquet
  size:    307 KB
  rows:    10,348

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-22 04:00:00	SPY	ETF	164.72	164.98	164.64	164.86	23231.0
2013-08-22 04:30:00	SPY	ETF	164.84	164.95	164.84	164.95	15700.0
2013-08-22 05:00:00	SPY	ETF	164.95	165.01	164.88	164.94	19350.0
2013-08-22 05:30:00	SPY	ETF	164.96	165.04	164.8	164.82	38150.0
2013-08-22 06:00:00	SPY	ETF	164.81	164.94	164.79	164.86	54550.0
2013-08-22 06:30:00	SPY	ETF	164.86	164.86	164.76	164.8	85675.0
2013-08-22 07:00:00	SPY	ETF	164.79	164.93	164.76	164.93	99362.0
2013-08-22 07:30:00	SPY	ETF	164.89	164.9	164.63	164.65	312362.0
2013-08-22 08:00:00	SPY	ETF	164.65	164.93	164.64	164.78	671280.0
2013-08-22 08:30:00	SPY	ETF	164.78	165.12	164.74	165.01	900790.0
2013-08-22 09:00:00	SPY	ETF	165.02	165.05	164.87	164.9	1095033.0
2013-08-22 09:30:00	SPY	ETF	164.9	165.5	164.89	165.39	12788881.0
2013-08-22 10:00:00	SPY	ETF	165.38	165.73	165.28	165.71	10279408.0
2013-08-22 10:30:00	SPY	ETF	165.72	165.97	165.67	165.7401	7834386.0
2013-08-22 11:00:00	SPY	ETF	165.75	165.85	165.44	165.465	6724015.0
2013-08-22 11:30:00	SPY	ETF	165.48	165.7	165.46	165.67	3769503.0
2013-08-22 12:00:00	SPY	ETF	165.66	165.82	165.56	165.61	3790007.0
2013-08-22 12:30:00	SPY	ETF	165.61	165.79	165.3	165.41	4490484.0
2013-08-22 13:00:00	SPY	ETF	165.41	165.7	165.35	165.5988	3444571.0
2013-08-22 13:30:00	SPY	ETF	165.6	165.85	165.54	165.81	2608956.0
2013-08-22 14:00:00	SPY	ETF	165.82	165.9	165.72	165.84	3341046.0
2013-08-22 14:30:00	SPY	ETF	165.85	166.0	165.78	165.79	4021175.0
2013-08-22 15:00:00	SPY	ETF	165.781	166.13	165.71	166.07	5567685.0
2013-08-22 15:30:00	SPY	ETF	166.075	166.3	165.95	165.99	14295477.0
2013-08-22 16:00:00	SPY	ETF	166.02	166.2	164.582	166.04	5931934.0
2013-08-22 16:30:00	SPY	ETF	166.04	166.1496	165.6533	166.12	2311351.0
2013-08-22 17:00:00	SPY	ETF	166.12	166.15	166.1	166.14	45431.0
2013-08-22 17:30:00	SPY	ETF	166.14	166.16	166.1	166.12	14754.0
2013-08-22 18:00:00	SPY	ETF	166.09	166.11	166.06	166.1	28458.0
2013-08-22 18:30:00	SPY	ETF	166.12	166.19	166.12	166.17	31362.0
2013-08-22 19:00:00	SPY	ETF	166.18	166.25	166.17	166.25	17725.0
2013-08-22 19:30:00	SPY	ETF	166.23	166.25	166.16	166.2	12830.0
2013-08-22 04:00:00	QQQ	ETF	75.2	75.66	75.2	75.64	31100.0
2013-08-22 04:30:00	QQQ	ETF	75.62	75.67	75.62	75.67	4700.0
2013-08-22 05:00:00	QQQ	ETF	75.64	75.66	75.64	75.66	2200.0
2013-08-22 05:30:00	QQQ	ETF	75.68	75.7	75.62	75.62	6400.0
2013-08-22 06:00:00	QQQ	ETF	75.6	75.65	75.6	75.62	9500.0
2013-08-22 06:30:00	QQQ	ETF	75.62	75.63	75.59	75.62	18800.0
2013-08-22 07:00:00	QQQ	ETF	75.61	75.65	75.6	75.65	119200.0
2013-08-22 07:30:00	QQQ	ETF	75.64	75.65	75.56	75.56	22645.0
2013-08-22 08:00:00	QQQ	ETF	75.61	75.65	75.55	75.63	101605.0
2013-08-22 08:30:00	QQQ	ETF	75.62	75.74	75.6	75.71	73320.0
2013-08-22 09:00:00	QQQ	ETF	75.72	75.75	75.68	75.73	266916.0
2013-08-22 09:30:00	QQQ	ETF	75.73	76.05	75.71	75.96	3236971.0
2013-08-22 10:00:00	QQQ	ETF	75.96	76.1	75.85	76.035	2257272.0
2013-08-22 10:30:00	QQQ	ETF	76.04	76.21	76.02	76.11	1676066.0
2013-08-22 11:00:00	QQQ	ETF	76.11	76.15	75.94	75.96	2093913.0
2013-08-22 11:30:00	QQQ	ETF	75.95	76.06	75.925	75.9801	801620.0
2013-08-22 12:00:00	QQQ	ETF	75.98	75.995	75.95	75.96	369368.0
2013-08-22 12:30:00	QQQ	ETF	75.95	75.95	75.95	75.95	400.0

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

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