PREVIEW / etf_30min / 2012-10-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-18.parquet
  size:    281 KB
  rows:    9,551

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
2012-10-18 04:00:00	SPY	ETF	146.1	146.1	146.02	146.04	1100.0
2012-10-18 04:30:00	SPY	ETF	146.2	146.2	146.2	146.2	600.0
2012-10-18 05:30:00	SPY	ETF	146.18	146.26	146.18	146.18	28562.0
2012-10-18 06:00:00	SPY	ETF	146.2	146.24	146.2	146.24	200.0
2012-10-18 06:30:00	SPY	ETF	146.21	146.21	146.06	146.12	29400.0
2012-10-18 07:00:00	SPY	ETF	146.04	146.09	146.01	146.01	75643.0
2012-10-18 07:30:00	SPY	ETF	146.04	146.04	145.93	146.0	50636.0
2012-10-18 08:00:00	SPY	ETF	146.0	146.28	145.98	146.28	249940.0
2012-10-18 08:30:00	SPY	ETF	146.28	146.28	145.81	145.84	1131849.0
2012-10-18 09:00:00	SPY	ETF	145.83	145.85	145.73	145.83	559123.0
2012-10-18 09:30:00	SPY	ETF	145.82	146.0	145.75	145.98	12586538.0
2012-10-18 10:00:00	SPY	ETF	145.98	146.22	145.64	145.77	12905456.0
2012-10-18 10:30:00	SPY	ETF	145.76	146.09	145.75	146.0099	8058507.0
2012-10-18 11:00:00	SPY	ETF	146.0	146.15	145.99	146.11	5471368.0
2012-10-18 11:30:00	SPY	ETF	146.1	146.44	146.1	146.39	6227997.0
2012-10-18 12:00:00	SPY	ETF	146.39	146.52	146.37	146.41	4879640.0
2012-10-18 12:30:00	SPY	ETF	146.41	146.44	145.88	145.97	13702724.0
2012-10-18 13:00:00	SPY	ETF	145.97	146.03	145.68	145.94	8279846.0
2012-10-18 13:30:00	SPY	ETF	145.93	145.945	145.52	145.595	9260466.0
2012-10-18 14:00:00	SPY	ETF	145.595	145.91	145.565	145.64	6709915.0
2012-10-18 14:30:00	SPY	ETF	145.64	145.71	145.33	145.66	13015832.0
2012-10-18 15:00:00	SPY	ETF	145.66	145.84	145.51	145.78	11114341.0
2012-10-18 15:30:00	SPY	ETF	145.78	146.0	145.745	145.87	14413520.0
2012-10-18 16:00:00	SPY	ETF	145.87	146.4075	145.65	145.7	9924388.0
2012-10-18 16:30:00	SPY	ETF	145.68	146.129	145.56	145.66	5116054.0
2012-10-18 17:00:00	SPY	ETF	145.68	145.7	145.6	145.68	379945.0
2012-10-18 17:30:00	SPY	ETF	145.7	145.72	145.65	145.69	38831.0
2012-10-18 18:00:00	SPY	ETF	145.66	145.74	145.64	145.67	70242.0
2012-10-18 18:30:00	SPY	ETF	145.66	145.71	145.62	145.71	18200.0
2012-10-18 19:00:00	SPY	ETF	145.72	145.78	145.72	145.78	14600.0
2012-10-18 19:30:00	SPY	ETF	145.75	145.81	145.75	145.8	22815.0
2012-10-18 04:00:00	QQQ	ETF	68.03	68.03	68.02	68.02	2603.0
2012-10-18 06:30:00	QQQ	ETF	68.02	68.06	68.02	68.02	2400.0
2012-10-18 07:00:00	QQQ	ETF	67.97	67.99	67.97	67.99	10842.0
2012-10-18 07:30:00	QQQ	ETF	67.97	67.97	67.92	67.92	7700.0
2012-10-18 08:00:00	QQQ	ETF	67.94	68.15	67.92	67.92	173554.0
2012-10-18 08:30:00	QQQ	ETF	67.88	67.9	67.78	67.79	309889.0
2012-10-18 09:00:00	QQQ	ETF	67.79	67.87	67.77	67.86	217391.0
2012-10-18 09:30:00	QQQ	ETF	67.87	67.95	67.73	67.939	3883735.0
2012-10-18 10:00:00	QQQ	ETF	67.93	68.03	67.61	67.69	3634109.0
2012-10-18 10:30:00	QQQ	ETF	67.68	67.83	67.64	67.7985	2287740.0
2012-10-18 11:00:00	QQQ	ETF	67.7901	67.86	67.78	67.82	1729472.0
2012-10-18 11:30:00	QQQ	ETF	67.83	68.03	67.83	68.02	2342108.0
2012-10-18 12:00:00	QQQ	ETF	68.02	68.08	68.0	68.02	959950.0
2012-10-18 12:30:00	QQQ	ETF	68.02	68.04	67.35	67.44	12650203.0
2012-10-18 13:00:00	QQQ	ETF	67.4301	67.46	67.18	67.36	4746937.0
2012-10-18 13:30:00	QQQ	ETF	67.36	67.37	67.05	67.11	3271656.0
2012-10-18 14:00:00	QQQ	ETF	67.11	67.29	67.08	67.155	3534360.0
2012-10-18 14:30:00	QQQ	ETF	67.15	67.2	67.04	67.185	4206524.0
2012-10-18 15:00:00	QQQ	ETF	67.185	67.34	67.1	67.29	6058933.0

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

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