PREVIEW / etf_30min / 2011-07-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-01.parquet
  size:    282 KB
  rows:    9,466

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
2011-07-01 04:00:00	SPY	ETF	131.65	131.65	131.65	131.65	100.0
2011-07-01 04:30:00	SPY	ETF	132.01	132.02	132.01	132.02	4500.0
2011-07-01 05:00:00	SPY	ETF	131.97	132.01	131.94	132.01	1672.0
2011-07-01 05:30:00	SPY	ETF	132.0	132.0	131.87	131.89	13400.0
2011-07-01 06:00:00	SPY	ETF	132.03	132.12	132.01	132.01	14200.0
2011-07-01 06:30:00	SPY	ETF	132.1	132.15	132.01	132.05	44130.0
2011-07-01 07:00:00	SPY	ETF	132.03	132.07	131.92	132.0	89093.0
2011-07-01 07:30:00	SPY	ETF	132.0	132.1	131.9	132.01	676130.0
2011-07-01 08:00:00	SPY	ETF	131.98	132.15	131.9	132.1	1425991.0
2011-07-01 08:30:00	SPY	ETF	132.11	132.18	131.8778	132.0	1178884.0
2011-07-01 09:00:00	SPY	ETF	131.99	132.11	131.93	132.01	1272452.0
2011-07-01 09:30:00	SPY	ETF	132.01	132.15	131.78	132.11	20968578.0
2011-07-01 10:00:00	SPY	ETF	132.11	133.07	132.09	133.0	40224203.0
2011-07-01 10:30:00	SPY	ETF	133.0	133.23	132.93	132.96	17019996.0
2011-07-01 11:00:00	SPY	ETF	132.96	133.21	132.93	133.18	8308023.0
2011-07-01 11:30:00	SPY	ETF	133.18	133.28	133.11	133.19	9127329.0
2011-07-01 12:00:00	SPY	ETF	133.19	133.4	133.13	133.36	6771122.0
2011-07-01 12:30:00	SPY	ETF	133.36	133.38	133.26	133.37	4801039.0
2011-07-01 13:00:00	SPY	ETF	133.37	133.61	133.32	133.57	7517201.0
2011-07-01 13:30:00	SPY	ETF	133.58	133.74	133.52	133.68	9625612.0
2011-07-01 14:00:00	SPY	ETF	133.67	133.77	133.59	133.72	7859255.0
2011-07-01 14:30:00	SPY	ETF	133.73	134.01	133.69	133.97	8949573.0
2011-07-01 15:00:00	SPY	ETF	133.96	134.0	133.74	133.8	13875974.0
2011-07-01 15:30:00	SPY	ETF	133.8	134.1	133.75	133.91	25364554.0
2011-07-01 16:00:00	SPY	ETF	133.92	134.01	132.4	133.96	9249043.0
2011-07-01 16:30:00	SPY	ETF	133.99	133.99	133.89	133.91	5845489.0
2011-07-01 17:00:00	SPY	ETF	133.89	133.95	133.86	133.86	135381.0
2011-07-01 17:30:00	SPY	ETF	133.94	134.05	133.91	133.99	115025.0
2011-07-01 18:00:00	SPY	ETF	133.98	134.09	133.93	134.0	414695.0
2011-07-01 18:30:00	SPY	ETF	133.99	134.02	133.97	134.01	5322.0
2011-07-01 19:00:00	SPY	ETF	133.98	134.01	133.98	133.99	2088.0
2011-07-01 19:30:00	SPY	ETF	134.0	134.02	133.97	134.0	12905.0
2011-07-01 05:00:00	QQQ	ETF	57.02	57.02	57.02	57.02	1100.0
2011-07-01 06:00:00	QQQ	ETF	57.17	57.17	57.06	57.06	400.0
2011-07-01 06:30:00	QQQ	ETF	57.08	57.08	57.08	57.08	4000.0
2011-07-01 07:00:00	QQQ	ETF	57.08	57.11	57.08	57.1	2190.0
2011-07-01 07:30:00	QQQ	ETF	57.07	57.12	57.03	57.05	11400.0
2011-07-01 08:00:00	QQQ	ETF	57.05	57.1	57.03	57.08	110087.0
2011-07-01 08:30:00	QQQ	ETF	57.08	57.13	57.04	57.04	106322.0
2011-07-01 09:00:00	QQQ	ETF	57.05	57.08	57.03	57.08	249714.0
2011-07-01 09:30:00	QQQ	ETF	57.08	57.18	56.92	57.16	3847744.0
2011-07-01 10:00:00	QQQ	ETF	57.15	57.47	57.14	57.42	9751245.0
2011-07-01 10:30:00	QQQ	ETF	57.42	57.5	57.41	57.45	3529952.0
2011-07-01 11:00:00	QQQ	ETF	57.46	57.58	57.42	57.56	2556836.0
2011-07-01 11:30:00	QQQ	ETF	57.5689	57.65	57.551	57.605	2138489.0
2011-07-01 12:00:00	QQQ	ETF	57.605	57.73	57.58	57.7	3054361.0
2011-07-01 12:30:00	QQQ	ETF	57.7	57.71	57.64	57.685	1229696.0
2011-07-01 13:00:00	QQQ	ETF	57.68	57.82	57.66	57.801	1798483.0
2011-07-01 13:30:00	QQQ	ETF	57.8	57.89	57.76	57.86	2945591.0
2011-07-01 14:00:00	QQQ	ETF	57.865	57.91	57.8	57.87	1794754.0

> showing 50 of 9,466 rows — these rows as CSV

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