PREVIEW / etf_30min / 2012-09-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-05.parquet
  size:    272 KB
  rows:    9,432

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-09-05 04:00:00	SPY	ETF	140.65	140.65	140.5	140.5	3060.0
2012-09-05 05:00:00	SPY	ETF	140.58	140.58	140.53	140.53	20200.0
2012-09-05 05:30:00	SPY	ETF	140.71	141.02	140.71	141.02	665.0
2012-09-05 06:00:00	SPY	ETF	141.02	141.02	140.96	140.97	4736.0
2012-09-05 06:30:00	SPY	ETF	140.96	140.98	140.93	140.98	45067.0
2012-09-05 07:00:00	SPY	ETF	140.98	140.99	140.7	140.83	66020.0
2012-09-05 07:30:00	SPY	ETF	140.87	140.92	140.75	140.75	885716.0
2012-09-05 08:00:00	SPY	ETF	140.76	141.29	140.7	140.89	3831353.0
2012-09-05 08:30:00	SPY	ETF	140.89	141.28	140.88	141.19	1149504.0
2012-09-05 09:00:00	SPY	ETF	141.2	141.28	140.87	141.08	731921.0
2012-09-05 09:30:00	SPY	ETF	141.09	141.2	140.63	140.92	13488823.0
2012-09-05 10:00:00	SPY	ETF	140.91	141.34	140.85	141.34	15015154.0
2012-09-05 10:30:00	SPY	ETF	141.34	141.47	140.88	140.89	9683736.0
2012-09-05 11:00:00	SPY	ETF	140.89	141.2	140.8	141.2	5591125.0
2012-09-05 11:30:00	SPY	ETF	141.17	141.3	141.1	141.145	3590373.0
2012-09-05 12:00:00	SPY	ETF	141.15	141.25	141.12	141.22	3462186.0
2012-09-05 12:30:00	SPY	ETF	141.21	141.24	141.14	141.17	2401166.0
2012-09-05 13:00:00	SPY	ETF	141.18	141.2	141.08	141.0918	2343090.0
2012-09-05 13:30:00	SPY	ETF	141.0918	141.095	140.65	140.839	7787546.0
2012-09-05 14:00:00	SPY	ETF	140.84	140.92	140.76	140.895	3772715.0
2012-09-05 14:30:00	SPY	ETF	140.89	141.06	140.88	140.985	3191955.0
2012-09-05 15:00:00	SPY	ETF	140.97	141.0	140.8	140.93	4631557.0
2012-09-05 15:30:00	SPY	ETF	140.93	141.05	140.81	140.91	9520166.0
2012-09-05 16:00:00	SPY	ETF	140.9	141.05	140.87	140.99	2621620.0
2012-09-05 16:30:00	SPY	ETF	141.0	141.18	141.0	141.16	4558364.0
2012-09-05 17:00:00	SPY	ETF	141.15	141.15	141.07	141.09	82368.0
2012-09-05 17:30:00	SPY	ETF	141.11	141.14	141.08	141.14	14410.0
2012-09-05 18:00:00	SPY	ETF	141.13	141.13	141.08	141.11	16050.0
2012-09-05 18:30:00	SPY	ETF	141.12	141.15	141.07	141.07	100825.0
2012-09-05 19:00:00	SPY	ETF	141.07	141.07	141.02	141.04	31810.0
2012-09-05 19:30:00	SPY	ETF	141.04	141.12	141.04	141.09	29225.0
2012-09-05 05:00:00	QQQ	ETF	67.82	67.82	67.82	67.82	200.0
2012-09-05 07:00:00	QQQ	ETF	68.04	68.04	67.98	67.98	3500.0
2012-09-05 07:30:00	QQQ	ETF	68.01	68.01	67.86	67.86	638972.0
2012-09-05 08:00:00	QQQ	ETF	67.86	68.11	67.86	67.92	878100.0
2012-09-05 08:30:00	QQQ	ETF	67.96	68.13	67.95	68.09	106326.0
2012-09-05 09:00:00	QQQ	ETF	68.09	68.12	67.99	68.04	98605.0
2012-09-05 09:30:00	QQQ	ETF	68.03	68.19	67.84	68.14	4399641.0
2012-09-05 10:00:00	QQQ	ETF	68.15	68.35	68.11	68.29	3419661.0
2012-09-05 10:30:00	QQQ	ETF	68.29	68.35	68.0	68.0	1897831.0
2012-09-05 11:00:00	QQQ	ETF	68.0	68.22	67.9	68.2	2201666.0
2012-09-05 11:30:00	QQQ	ETF	68.19	68.27	68.17	68.191	1191131.0
2012-09-05 12:00:00	QQQ	ETF	68.195	68.29	68.18	68.25	684353.0
2012-09-05 12:30:00	QQQ	ETF	68.25	68.32	68.1999	68.26	715406.0
2012-09-05 13:00:00	QQQ	ETF	68.26	68.27	68.2	68.22	381402.0
2012-09-05 13:30:00	QQQ	ETF	68.22	68.22	67.94	68.02	1963892.0
2012-09-05 14:00:00	QQQ	ETF	68.03	68.07	67.97	68.05	765463.0
2012-09-05 14:30:00	QQQ	ETF	68.055	68.16	68.05	68.1	683998.0
2012-09-05 15:00:00	QQQ	ETF	68.1	68.11	67.97	68.01	1909327.0
2012-09-05 15:30:00	QQQ	ETF	68.01	68.09	67.93	68.01	2499248.0

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

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