PREVIEW / etf_30min / 2013-03-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-18.parquet
  size:    305 KB
  rows:    10,583

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-03-18 04:00:00	SPY	ETF	154.15	154.3	154.02	154.3	53236.0
2013-03-18 04:30:00	SPY	ETF	154.22	154.3	154.22	154.29	10846.0
2013-03-18 05:00:00	SPY	ETF	154.31	154.48	154.21	154.48	64093.0
2013-03-18 05:30:00	SPY	ETF	154.48	154.54	154.46	154.46	14811.0
2013-03-18 06:00:00	SPY	ETF	154.55	154.57	154.24	154.24	37500.0
2013-03-18 06:30:00	SPY	ETF	154.23	154.34	154.13	154.25	195125.0
2013-03-18 07:00:00	SPY	ETF	154.27	154.43	154.27	154.32	410098.0
2013-03-18 07:30:00	SPY	ETF	154.32	154.53	154.3	154.5	540768.0
2013-03-18 08:00:00	SPY	ETF	154.5	154.63	153.95	154.49	1503623.0
2013-03-18 08:30:00	SPY	ETF	154.49	154.73	153.8	154.5	1055141.0
2013-03-18 09:00:00	SPY	ETF	154.52	154.56	154.23	154.33	1164065.0
2013-03-18 09:30:00	SPY	ETF	154.34	154.88	154.2	154.82	19791630.0
2013-03-18 10:00:00	SPY	ETF	154.81	155.12	154.7	155.059	11534786.0
2013-03-18 10:30:00	SPY	ETF	155.06	155.16	154.92	154.95	6504343.0
2013-03-18 11:00:00	SPY	ETF	154.965	155.21	154.91	155.099	6436628.0
2013-03-18 11:30:00	SPY	ETF	155.098	155.29	155.03	155.28	5136000.0
2013-03-18 12:00:00	SPY	ETF	155.28	155.605	155.28	155.39	9138271.0
2013-03-18 12:30:00	SPY	ETF	155.38	155.42	155.28	155.4	4641239.0
2013-03-18 13:00:00	SPY	ETF	155.4	155.47	155.25	155.265	3298376.0
2013-03-18 13:30:00	SPY	ETF	155.27	155.33	155.16	155.179	6003025.0
2013-03-18 14:00:00	SPY	ETF	155.179	155.64	155.16	155.62	3695415.0
2013-03-18 14:30:00	SPY	ETF	155.63	155.64	155.25	155.28	5253026.0
2013-03-18 15:00:00	SPY	ETF	155.28	155.46	154.94	155.0	12077132.0
2013-03-18 15:30:00	SPY	ETF	154.995	155.03	154.75	154.95	17595727.0
2013-03-18 16:00:00	SPY	ETF	154.95	155.47	154.85	155.13	6198896.0
2013-03-18 16:30:00	SPY	ETF	155.13	155.8309	155.08	155.165	2233114.0
2013-03-18 17:00:00	SPY	ETF	155.17	155.19	154.97	155.13	65861.0
2013-03-18 17:30:00	SPY	ETF	155.13	155.18	155.13	155.17	52971.0
2013-03-18 18:00:00	SPY	ETF	155.17	155.17	155.07	155.11	30221.0
2013-03-18 18:30:00	SPY	ETF	155.1	155.15	155.08	155.13	25514.0
2013-03-18 19:00:00	SPY	ETF	155.15	155.15	155.08	155.13	27268.0
2013-03-18 19:30:00	SPY	ETF	155.13	155.2	155.11	155.18	28416.0
2013-03-18 04:00:00	QQQ	ETF	67.91	67.91	67.72	67.72	597.0
2013-03-18 04:30:00	QQQ	ETF	67.69	67.69	67.67	67.67	480.0
2013-03-18 05:00:00	QQQ	ETF	67.73	67.78	67.73	67.78	900.0
2013-03-18 06:30:00	QQQ	ETF	67.78	67.78	67.77	67.77	396.0
2013-03-18 07:00:00	QQQ	ETF	67.79	67.83	67.78	67.8	5704.0
2013-03-18 07:30:00	QQQ	ETF	67.81	67.92	67.8	67.92	18029.0
2013-03-18 08:00:00	QQQ	ETF	67.92	68.0	67.77	67.97	59746.0
2013-03-18 08:30:00	QQQ	ETF	67.96	68.03	67.92	67.94	359642.0
2013-03-18 09:00:00	QQQ	ETF	67.935	67.96	67.84	67.89	268189.0
2013-03-18 09:30:00	QQQ	ETF	67.89	68.14	67.73	68.11	3922892.0
2013-03-18 10:00:00	QQQ	ETF	68.1	68.35	68.08	68.31	2852863.0
2013-03-18 10:30:00	QQQ	ETF	68.319	68.36	68.199	68.24	1196136.0
2013-03-18 11:00:00	QQQ	ETF	68.24	68.35	68.22	68.29	1093912.0
2013-03-18 11:30:00	QQQ	ETF	68.29	68.42	68.26	68.41	933686.0
2013-03-18 12:00:00	QQQ	ETF	68.42	68.6001	68.42	68.51	3302152.0
2013-03-18 12:30:00	QQQ	ETF	68.51	68.53	68.42	68.46	2342057.0
2013-03-18 13:00:00	QQQ	ETF	68.459	68.552	68.43	68.46	518088.0
2013-03-18 13:30:00	QQQ	ETF	68.465	68.49	68.4	68.4	617942.0

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

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