PREVIEW / etf_30min / 2013-10-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-24.parquet
  size:    322 KB
  rows:    11,112

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-10-24 04:00:00	SPY	ETF	175.15	175.38	174.93	175.24	26420.0
2013-10-24 04:30:00	SPY	ETF	175.25	175.27	175.21	175.23	9005.0
2013-10-24 05:00:00	SPY	ETF	175.21	175.21	175.11	175.18	7190.0
2013-10-24 05:30:00	SPY	ETF	175.14	175.24	175.14	175.24	5200.0
2013-10-24 06:00:00	SPY	ETF	175.26	175.39	175.25	175.37	66250.0
2013-10-24 06:30:00	SPY	ETF	175.37	175.55	175.37	175.43	150350.0
2013-10-24 07:00:00	SPY	ETF	175.43	175.47	175.3	175.32	195406.0
2013-10-24 07:30:00	SPY	ETF	175.28	175.34	175.19	175.23	77968.0
2013-10-24 08:00:00	SPY	ETF	175.25	175.41	175.12	175.17	218998.0
2013-10-24 08:30:00	SPY	ETF	175.2	175.22	174.98	174.98	609336.0
2013-10-24 09:00:00	SPY	ETF	174.98	175.12	174.84	174.91	520851.0
2013-10-24 09:30:00	SPY	ETF	174.92	175.02	174.51	174.777	10557310.0
2013-10-24 10:00:00	SPY	ETF	174.78	175.02	174.56	174.71	6763170.0
2013-10-24 10:30:00	SPY	ETF	174.73	174.93	174.58	174.9008	5403863.0
2013-10-24 11:00:00	SPY	ETF	174.91	175.16	174.85	175.11	5398837.0
2013-10-24 11:30:00	SPY	ETF	175.12	175.14	174.98	175.05	3458062.0
2013-10-24 12:00:00	SPY	ETF	175.06	175.13	174.98	175.05	2799598.0
2013-10-24 12:30:00	SPY	ETF	175.05	175.23	174.83	175.21	3565890.0
2013-10-24 13:00:00	SPY	ETF	175.21	175.22	174.95	175.15	3127938.0
2013-10-24 13:30:00	SPY	ETF	175.15	175.16	175.01	175.055	2955829.0
2013-10-24 14:00:00	SPY	ETF	175.06	175.21	175.01	175.16	2534668.0
2013-10-24 14:30:00	SPY	ETF	175.16	175.36	175.11	175.35	3120563.0
2013-10-24 15:00:00	SPY	ETF	175.35	175.37	175.2	175.22	3718787.0
2013-10-24 15:30:00	SPY	ETF	175.221	175.26	175.03	175.15	9404793.0
2013-10-24 16:00:00	SPY	ETF	175.17	175.5	174.77	175.37	4258965.0
2013-10-24 16:30:00	SPY	ETF	175.37	175.45	174.9181	175.4	244618.0
2013-10-24 17:00:00	SPY	ETF	175.4	175.43	175.35	175.43	171840.0
2013-10-24 17:30:00	SPY	ETF	175.4	175.4	175.35	175.35	48000.0
2013-10-24 18:00:00	SPY	ETF	175.35	175.43	175.32	175.4	136385.0
2013-10-24 18:30:00	SPY	ETF	175.4	175.43	175.37	175.37	34975.0
2013-10-24 19:00:00	SPY	ETF	175.37	175.4	175.36	175.39	9697.0
2013-10-24 19:30:00	SPY	ETF	175.4	175.4	175.38	175.39	38790.0
2013-10-24 04:00:00	QQQ	ETF	82.22	82.26	82.2	82.26	40500.0
2013-10-24 04:30:00	QQQ	ETF	82.25	82.26	82.22	82.25	21500.0
2013-10-24 05:00:00	QQQ	ETF	82.24	82.24	82.19	82.23	4800.0
2013-10-24 05:30:00	QQQ	ETF	82.22	82.26	82.19	82.26	6968.0
2013-10-24 06:00:00	QQQ	ETF	82.25	82.32	82.25	82.31	17050.0
2013-10-24 06:30:00	QQQ	ETF	82.3	82.37	82.3	82.32	60700.0
2013-10-24 07:00:00	QQQ	ETF	82.32	82.32	82.24	82.25	31597.0
2013-10-24 07:30:00	QQQ	ETF	82.24	82.29	82.22	82.23	14263.0
2013-10-24 08:00:00	QQQ	ETF	82.24	82.29	82.16	82.18	21358.0
2013-10-24 08:30:00	QQQ	ETF	82.18	82.18	82.03	82.04	102064.0
2013-10-24 09:00:00	QQQ	ETF	82.04	82.13	81.96	81.99	160623.0
2013-10-24 09:30:00	QQQ	ETF	81.99	82.13	81.88	82.11	3486092.0
2013-10-24 10:00:00	QQQ	ETF	82.1	82.23	82.02	82.1099	2042193.0
2013-10-24 10:30:00	QQQ	ETF	82.11	82.22	82.02	82.22	1730386.0
2013-10-24 11:00:00	QQQ	ETF	82.2199	82.425	82.19	82.39	2177666.0
2013-10-24 11:30:00	QQQ	ETF	82.4	82.44	82.34	82.35	1133747.0
2013-10-24 12:00:00	QQQ	ETF	82.34	82.4399	82.3	82.401	961369.0
2013-10-24 12:30:00	QQQ	ETF	82.4099	82.48	82.2901	82.46	980055.0

> showing 50 of 11,112 rows — these rows as CSV

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