PREVIEW / etf_30min / 2013-05-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-30.parquet
  size:    316 KB
  rows:    10,737

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-05-30 04:00:00	SPY	ETF	165.1	165.23	164.95	164.95	11700.0
2013-05-30 04:30:00	SPY	ETF	164.93	165.0	164.8	164.8	2925.0
2013-05-30 05:00:00	SPY	ETF	164.85	165.05	164.8	165.05	29400.0
2013-05-30 05:30:00	SPY	ETF	165.0	165.15	164.95	165.05	86400.0
2013-05-30 06:00:00	SPY	ETF	164.995	165.33	164.88	165.23	36050.0
2013-05-30 06:30:00	SPY	ETF	165.31	165.59	165.27	165.52	188310.0
2013-05-30 07:00:00	SPY	ETF	165.5	166.0	165.5	165.87	400870.0
2013-05-30 07:30:00	SPY	ETF	165.88	165.91	165.69	165.705	201898.0
2013-05-30 08:00:00	SPY	ETF	165.57	165.95	164.6	165.79	327190.0
2013-05-30 08:30:00	SPY	ETF	165.87	166.12	165.46	165.53	1044656.0
2013-05-30 09:00:00	SPY	ETF	165.55	165.63	165.27	165.35	910225.0
2013-05-30 09:30:00	SPY	ETF	165.35	166.3099	165.22	166.2	14997434.0
2013-05-30 10:00:00	SPY	ETF	166.2	166.37	165.8	165.9	13048507.0
2013-05-30 10:30:00	SPY	ETF	165.91	166.22	165.89	166.18	7805988.0
2013-05-30 11:00:00	SPY	ETF	166.185	166.24	165.77	166.0096	8695177.0
2013-05-30 11:30:00	SPY	ETF	166.01	166.26	165.99	166.255	4618577.0
2013-05-30 12:00:00	SPY	ETF	166.25	166.44	166.12	166.16	5717056.0
2013-05-30 12:30:00	SPY	ETF	166.15	166.19	165.97	166.18	5319811.0
2013-05-30 13:00:00	SPY	ETF	166.189	166.29	166.03	166.28	3390883.0
2013-05-30 13:30:00	SPY	ETF	166.281	166.44	166.23	166.361	4014858.0
2013-05-30 14:00:00	SPY	ETF	166.37	166.52	166.231	166.52	3790300.0
2013-05-30 14:30:00	SPY	ETF	166.51	166.59	166.36	166.51	3869593.0
2013-05-30 15:00:00	SPY	ETF	166.5	166.52	166.16	166.18	6142412.0
2013-05-30 15:30:00	SPY	ETF	166.18	166.25	165.8	165.82	15742516.0
2013-05-30 16:00:00	SPY	ETF	165.84	166.0815	165.35	165.85	4261231.0
2013-05-30 16:30:00	SPY	ETF	165.85	165.91	165.83	165.88	361301.0
2013-05-30 17:00:00	SPY	ETF	165.91	165.92	165.88	165.89	88054.0
2013-05-30 17:30:00	SPY	ETF	165.88	165.9	165.84	165.89	114326.0
2013-05-30 18:00:00	SPY	ETF	165.9	165.9	165.62	165.69	136947.0
2013-05-30 18:30:00	SPY	ETF	165.7	165.77	165.68	165.76	33823.0
2013-05-30 19:00:00	SPY	ETF	165.76	165.82	165.74	165.81	1031414.0
2013-05-30 19:30:00	SPY	ETF	165.8	165.86	165.79	165.85	47050.0
2013-05-30 04:00:00	QQQ	ETF	73.34	73.34	73.34	73.34	200.0
2013-05-30 04:30:00	QQQ	ETF	73.33	73.33	73.33	73.33	100.0
2013-05-30 05:30:00	QQQ	ETF	73.38	73.38	73.38	73.38	1000.0
2013-05-30 06:00:00	QQQ	ETF	73.37	73.37	73.34	73.34	600.0
2013-05-30 06:30:00	QQQ	ETF	73.52	73.64	73.52	73.64	2300.0
2013-05-30 07:00:00	QQQ	ETF	73.62	73.83	73.62	73.8	81295.0
2013-05-30 07:30:00	QQQ	ETF	73.77	73.77	73.7	73.7	10200.0
2013-05-30 08:00:00	QQQ	ETF	73.7	73.73	73.65	73.73	28395.0
2013-05-30 08:30:00	QQQ	ETF	73.67	73.79	73.57	73.61	115769.0
2013-05-30 09:00:00	QQQ	ETF	73.62	73.66	73.48	73.55	170781.0
2013-05-30 09:30:00	QQQ	ETF	73.56	74.0099	73.55	73.98	3517806.0
2013-05-30 10:00:00	QQQ	ETF	73.98	74.03	73.82	73.91	2593269.0
2013-05-30 10:30:00	QQQ	ETF	73.92	74.06	73.91	74.06	2263922.0
2013-05-30 11:00:00	QQQ	ETF	74.06	74.11	73.93	74.03	4184184.0
2013-05-30 11:30:00	QQQ	ETF	74.03	74.11	74.02	74.1	1082080.0
2013-05-30 12:00:00	QQQ	ETF	74.1	74.18	74.06	74.075	1488131.0
2013-05-30 12:30:00	QQQ	ETF	74.065	74.09	73.99	74.09	904210.0
2013-05-30 13:00:00	QQQ	ETF	74.1	74.155	74.03	74.15	919434.0

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

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