PREVIEW / etf_30min / 2013-08-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-19.parquet
  size:    324 KB
  rows:    10,858

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-19 04:00:00	SPY	ETF	165.7	165.7	165.56	165.64	6700.0
2013-08-19 04:30:00	SPY	ETF	165.66	165.66	165.55	165.62	6404.0
2013-08-19 05:00:00	SPY	ETF	165.62	165.76	165.62	165.75	17900.0
2013-08-19 05:30:00	SPY	ETF	165.78	165.84	165.71	165.71	12161.0
2013-08-19 06:00:00	SPY	ETF	165.71	165.82	165.66	165.72	7800.0
2013-08-19 06:30:00	SPY	ETF	165.68	165.68	165.6	165.63	26300.0
2013-08-19 07:00:00	SPY	ETF	165.64	165.66	165.5	165.5	82779.0
2013-08-19 07:30:00	SPY	ETF	165.53	165.55	165.4	165.46	163407.0
2013-08-19 08:00:00	SPY	ETF	165.44	165.59	165.35	165.54	267891.0
2013-08-19 08:30:00	SPY	ETF	165.54	165.77	165.42	165.67	485312.0
2013-08-19 09:00:00	SPY	ETF	165.67	165.69	165.51	165.63	292139.0
2013-08-19 09:30:00	SPY	ETF	165.64	166.09	165.4	166.08	12447765.0
2013-08-19 10:00:00	SPY	ETF	166.07	166.21	165.86	165.91	6323181.0
2013-08-19 10:30:00	SPY	ETF	165.905	166.14	165.83	165.94	6518041.0
2013-08-19 11:00:00	SPY	ETF	165.935	165.97	165.73	165.78	6648968.0
2013-08-19 11:30:00	SPY	ETF	165.77	165.88	165.64	165.72	4646996.0
2013-08-19 12:00:00	SPY	ETF	165.71	165.8	165.6	165.69	3423211.0
2013-08-19 12:30:00	SPY	ETF	165.69	165.81	165.58	165.73	4619030.0
2013-08-19 13:00:00	SPY	ETF	165.73	165.74	165.45	165.475	2767488.0
2013-08-19 13:30:00	SPY	ETF	165.47	165.51	165.26	165.5	4581946.0
2013-08-19 14:00:00	SPY	ETF	165.5	165.56	165.35	165.41	2876786.0
2013-08-19 14:30:00	SPY	ETF	165.415	165.5903	165.22	165.38	7014997.0
2013-08-19 15:00:00	SPY	ETF	165.38	165.39	165.07	165.1	7326900.0
2013-08-19 15:30:00	SPY	ETF	165.1	165.19	164.76	164.77	14473803.0
2013-08-19 16:00:00	SPY	ETF	164.78	165.8661	164.76	164.99	9876242.0
2013-08-19 16:30:00	SPY	ETF	164.99	164.99	164.92	164.955	267492.0
2013-08-19 17:00:00	SPY	ETF	164.96	164.96	164.92	164.96	123408.0
2013-08-19 17:30:00	SPY	ETF	164.96	164.96	164.94	164.95	17930.0
2013-08-19 18:00:00	SPY	ETF	164.99	165.11	164.98	165.01	77136.0
2013-08-19 18:30:00	SPY	ETF	165.0	165.01	164.97	164.97	8720.0
2013-08-19 19:00:00	SPY	ETF	164.97	165.0	164.97	164.98	7589.0
2013-08-19 19:30:00	SPY	ETF	164.99	165.01	164.97	164.98	13319.0
2013-08-19 04:00:00	QQQ	ETF	75.39	75.43	75.38	75.43	13000.0
2013-08-19 04:30:00	QQQ	ETF	75.41	75.43	75.41	75.43	2200.0
2013-08-19 05:00:00	QQQ	ETF	75.45	75.47	75.45	75.47	2100.0
2013-08-19 05:30:00	QQQ	ETF	75.51	75.53	75.49	75.49	4200.0
2013-08-19 06:00:00	QQQ	ETF	75.51	75.53	75.49	75.49	4200.0
2013-08-19 06:30:00	QQQ	ETF	75.46	75.46	75.43	75.45	4000.0
2013-08-19 07:00:00	QQQ	ETF	75.45	75.47	75.43	75.43	7250.0
2013-08-19 07:30:00	QQQ	ETF	75.43	75.43	75.39	75.41	4600.0
2013-08-19 08:00:00	QQQ	ETF	75.4	75.48	75.37	75.42	65636.0
2013-08-19 08:30:00	QQQ	ETF	75.42	75.55	75.36	75.51	75125.0
2013-08-19 09:00:00	QQQ	ETF	75.5	75.5	75.43	75.49	197927.0
2013-08-19 09:30:00	QQQ	ETF	75.49	75.9	75.41	75.9	3166970.0
2013-08-19 10:00:00	QQQ	ETF	75.9	76.05	75.8922	75.97	1938008.0
2013-08-19 10:30:00	QQQ	ETF	75.96	76.13	75.941	76.05	1437293.0
2013-08-19 11:00:00	QQQ	ETF	76.05	76.08	75.97	76.0001	796424.0
2013-08-19 11:30:00	QQQ	ETF	76.0	76.05	75.9	75.94	573756.0
2013-08-19 12:00:00	QQQ	ETF	75.932	75.97	75.88	75.92	425880.0
2013-08-19 12:30:00	QQQ	ETF	75.91	75.9865	75.83	75.95	687830.0

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

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