PREVIEW / etf_30min / 2013-08-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-26.parquet
  size:    317 KB
  rows:    10,788

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-08-26 04:00:00	SPY	ETF	166.62	166.62	166.6	166.62	2800.0
2013-08-26 04:30:00	SPY	ETF	166.6	166.6	166.54	166.58	4800.0
2013-08-26 05:00:00	SPY	ETF	166.54	166.6	166.54	166.59	14600.0
2013-08-26 05:30:00	SPY	ETF	166.6	166.65	166.54	166.54	5600.0
2013-08-26 06:00:00	SPY	ETF	166.54	166.56	166.5	166.51	21500.0
2013-08-26 06:30:00	SPY	ETF	166.5	166.5	166.41	166.48	9900.0
2013-08-26 07:00:00	SPY	ETF	166.52	166.69	166.52	166.66	38700.0
2013-08-26 07:30:00	SPY	ETF	166.66	166.66	166.54	166.54	76415.0
2013-08-26 08:00:00	SPY	ETF	166.54	166.69	166.45	166.49	241183.0
2013-08-26 08:30:00	SPY	ETF	166.48	167.11	166.28	166.75	761674.0
2013-08-26 09:00:00	SPY	ETF	166.76	166.86	166.69	166.78	378844.0
2013-08-26 09:30:00	SPY	ETF	166.79	167.0	166.53	166.811	8202722.0
2013-08-26 10:00:00	SPY	ETF	166.81	167.11	166.74	167.02	5390503.0
2013-08-26 10:30:00	SPY	ETF	167.02	167.2	166.91	167.18	4614039.0
2013-08-26 11:00:00	SPY	ETF	167.18	167.23	167.11	167.147	5121014.0
2013-08-26 11:30:00	SPY	ETF	167.15	167.3	167.06	167.12	3231910.0
2013-08-26 12:00:00	SPY	ETF	167.12	167.15	166.97	167.055	3493681.0
2013-08-26 12:30:00	SPY	ETF	167.0599	167.17	167.03	167.115	1592006.0
2013-08-26 13:00:00	SPY	ETF	167.11	167.19	167.01	167.01	2788939.0
2013-08-26 13:30:00	SPY	ETF	167.01	167.015	166.79	166.91	3195560.0
2013-08-26 14:00:00	SPY	ETF	166.902	166.95	166.84	166.9	2651910.0
2013-08-26 14:30:00	SPY	ETF	166.91	166.94	166.81	166.93	2060681.0
2013-08-26 15:00:00	SPY	ETF	166.94	166.97	165.89	166.17	12634125.0
2013-08-26 15:30:00	SPY	ETF	166.16	166.46	165.97	165.98	17053331.0
2013-08-26 16:00:00	SPY	ETF	165.99	167.1727	165.87	165.98	9285361.0
2013-08-26 16:30:00	SPY	ETF	165.98	166.89	165.92	166.0	1217781.0
2013-08-26 17:00:00	SPY	ETF	166.0	166.03	165.98	166.0	46119.0
2013-08-26 17:30:00	SPY	ETF	166.0	166.03	165.97	166.0	18672.0
2013-08-26 18:00:00	SPY	ETF	166.0	166.1	165.78	165.8	53117.0
2013-08-26 18:30:00	SPY	ETF	165.82	165.82	165.66	165.74	37160.0
2013-08-26 19:00:00	SPY	ETF	165.72	165.8	165.69	165.77	82010.0
2013-08-26 19:30:00	SPY	ETF	165.77	165.81	165.74	165.8	39870.0
2013-08-26 04:00:00	QQQ	ETF	76.61	76.62	76.6	76.61	4400.0
2013-08-26 04:30:00	QQQ	ETF	76.6	76.62	76.6	76.62	2300.0
2013-08-26 05:00:00	QQQ	ETF	76.66	76.66	76.66	76.66	1000.0
2013-08-26 05:30:00	QQQ	ETF	76.67	76.67	76.64	76.64	1150.0
2013-08-26 06:30:00	QQQ	ETF	76.6	76.62	76.6	76.62	2440.0
2013-08-26 07:00:00	QQQ	ETF	76.66	76.7	76.66	76.7	3000.0
2013-08-26 07:30:00	QQQ	ETF	76.7	76.7	76.66	76.66	7315.0
2013-08-26 08:00:00	QQQ	ETF	76.65	76.67	76.62	76.66	11703.0
2013-08-26 08:30:00	QQQ	ETF	77.35	78.23	76.64	76.74	54660.0
2013-08-26 09:00:00	QQQ	ETF	76.74	76.8	76.7	76.7	47961.0
2013-08-26 09:30:00	QQQ	ETF	76.72	77.0	76.6601	76.89	2086796.0
2013-08-26 10:00:00	QQQ	ETF	76.89	77.07	76.87	77.02	1670352.0
2013-08-26 10:30:00	QQQ	ETF	77.019	77.1	76.97	77.08	1351304.0
2013-08-26 11:00:00	QQQ	ETF	77.08	77.1786	77.07	77.17	1308161.0
2013-08-26 11:30:00	QQQ	ETF	77.17	77.22	77.11	77.14	1145352.0
2013-08-26 12:00:00	QQQ	ETF	77.14	77.2	77.09	77.17	1059994.0
2013-08-26 12:30:00	QQQ	ETF	77.16	77.26	77.155	77.24	793234.0
2013-08-26 13:00:00	QQQ	ETF	77.24	77.28	77.18	77.1835	844365.0

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

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