PREVIEW / etf_30min / 2013-06-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-19.parquet
  size:    322 KB
  rows:    10,836

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-06-19 04:00:00	SPY	ETF	165.61	165.77	165.41	165.72	3150.0
2013-06-19 04:30:00	SPY	ETF	165.73	165.94	165.62	165.84	6600.0
2013-06-19 05:00:00	SPY	ETF	165.88	165.94	165.79	165.94	10800.0
2013-06-19 05:30:00	SPY	ETF	165.96	166.02	165.96	165.96	2600.0
2013-06-19 06:00:00	SPY	ETF	165.97	165.97	165.86	165.9	3300.0
2013-06-19 06:30:00	SPY	ETF	165.9	165.93	165.74	165.78	17000.0
2013-06-19 07:00:00	SPY	ETF	165.78	165.8	165.55	165.6	121591.0
2013-06-19 07:30:00	SPY	ETF	165.6	165.61	165.49	165.61	132143.0
2013-06-19 08:00:00	SPY	ETF	165.56	165.81	165.52	165.77	317240.0
2013-06-19 08:30:00	SPY	ETF	165.78	165.78	165.58	165.62	145262.0
2013-06-19 09:00:00	SPY	ETF	165.61	165.67	165.56	165.63	468712.0
2013-06-19 09:30:00	SPY	ETF	165.6	165.83	165.23	165.41	11391722.0
2013-06-19 10:00:00	SPY	ETF	165.4	165.76	165.28	165.69	7904621.0
2013-06-19 10:30:00	SPY	ETF	165.68	165.78	165.45	165.55	5360429.0
2013-06-19 11:00:00	SPY	ETF	165.56	165.72	165.46	165.56	7605094.0
2013-06-19 11:30:00	SPY	ETF	165.56	165.72	165.43	165.45	4135592.0
2013-06-19 12:00:00	SPY	ETF	165.45	165.51	165.33	165.4799	7199881.0
2013-06-19 12:30:00	SPY	ETF	165.475	165.6	165.37	165.46	3722204.0
2013-06-19 13:00:00	SPY	ETF	165.46	165.59	165.41	165.51	5391700.0
2013-06-19 13:30:00	SPY	ETF	165.51	165.74	165.45	165.74	4268919.0
2013-06-19 14:00:00	SPY	ETF	165.72	165.89	164.73	165.299	30672005.0
2013-06-19 14:30:00	SPY	ETF	165.3	165.68	163.83	163.98	33210332.0
2013-06-19 15:00:00	SPY	ETF	163.99	164.72	163.83	164.64	21274333.0
2013-06-19 15:30:00	SPY	ETF	164.64	164.69	163.38	163.46	33306379.0
2013-06-19 16:00:00	SPY	ETF	163.49	165.7263	163.42	163.48	9652633.0
2013-06-19 16:30:00	SPY	ETF	163.46	165.7262	163.24	163.35	9505823.0
2013-06-19 17:00:00	SPY	ETF	163.38	165.7263	163.18	163.23	6205659.0
2013-06-19 17:30:00	SPY	ETF	163.27	163.28	163.24	163.25	64428.0
2013-06-19 18:00:00	SPY	ETF	163.25	163.4	163.25	163.39	158495.0
2013-06-19 18:30:00	SPY	ETF	163.4	163.43	163.35	163.43	25029.0
2013-06-19 19:00:00	SPY	ETF	163.39	163.39	163.3	163.3	28350.0
2013-06-19 19:30:00	SPY	ETF	163.3	163.34	163.27	163.28	27065.0
2013-06-19 04:00:00	QQQ	ETF	73.55	73.64	73.53	73.62	3000.0
2013-06-19 04:30:00	QQQ	ETF	73.6	73.74	73.6	73.7	3600.0
2013-06-19 05:00:00	QQQ	ETF	73.69	73.72	73.64	73.72	4300.0
2013-06-19 05:30:00	QQQ	ETF	73.74	73.74	73.72	73.72	10700.0
2013-06-19 06:00:00	QQQ	ETF	73.7	73.72	73.7	73.7	3400.0
2013-06-19 06:30:00	QQQ	ETF	73.7	73.7	73.66	73.66	4700.0
2013-06-19 07:00:00	QQQ	ETF	73.64	73.64	73.56	73.57	13700.0
2013-06-19 07:30:00	QQQ	ETF	73.56	73.57	73.52	73.56	7500.0
2013-06-19 08:00:00	QQQ	ETF	73.59	73.65	73.56	73.65	7200.0
2013-06-19 08:30:00	QQQ	ETF	73.62	73.62	73.56	73.6	11363.0
2013-06-19 09:00:00	QQQ	ETF	73.59	73.61	73.58	73.59	43509.0
2013-06-19 09:30:00	QQQ	ETF	73.58	73.68	73.43	73.52	2878300.0
2013-06-19 10:00:00	QQQ	ETF	73.51	73.66	73.46	73.63	1415367.0
2013-06-19 10:30:00	QQQ	ETF	73.62	73.67	73.5	73.55	1641055.0
2013-06-19 11:00:00	QQQ	ETF	73.55	73.62	73.51	73.55	959658.0
2013-06-19 11:30:00	QQQ	ETF	73.55	73.6	73.45	73.46	770504.0
2013-06-19 12:00:00	QQQ	ETF	73.45	73.51	73.41	73.4503	800420.0
2013-06-19 12:30:00	QQQ	ETF	73.456	73.49	73.41	73.43	898656.0

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

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