PREVIEW / etf_30min / 2014-10-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-15.parquet
  size:    412 KB
  rows:    13,502

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
2014-10-15 04:00:00	SPY	ETF	187.83	187.83	187.32	187.63	17909.0
2014-10-15 04:30:00	SPY	ETF	187.65	187.65	187.27	187.36	55992.0
2014-10-15 05:00:00	SPY	ETF	187.33	187.43	187.15	187.3	154351.0
2014-10-15 05:30:00	SPY	ETF	187.35	187.82	187.34	187.67	178859.0
2014-10-15 06:00:00	SPY	ETF	187.63	187.86	187.57	187.66	127364.0
2014-10-15 06:30:00	SPY	ETF	187.66	187.87	187.5	187.52	171794.0
2014-10-15 07:00:00	SPY	ETF	187.54	187.69	186.46	186.65	516993.0
2014-10-15 07:30:00	SPY	ETF	186.69	186.9	186.3	186.34	837909.0
2014-10-15 08:00:00	SPY	ETF	186.32	187.36	186.23	186.83	1670578.0
2014-10-15 08:30:00	SPY	ETF	186.8	186.8	185.42	185.7	5098896.0
2014-10-15 09:00:00	SPY	ETF	185.69	187.83	185.14	185.19	4215621.0
2014-10-15 09:30:00	SPY	ETF	185.16	186.07	183.65	185.87	47992500.0
2014-10-15 10:00:00	SPY	ETF	185.87	186.67	185.65	185.79	29327909.0
2014-10-15 10:30:00	SPY	ETF	185.78	185.94	184.92	185.51	20607204.0
2014-10-15 11:00:00	SPY	ETF	185.51	186.14	184.81	184.89	18332938.0
2014-10-15 11:30:00	SPY	ETF	184.89	185.27	184.26	184.8701	15281100.0
2014-10-15 12:00:00	SPY	ETF	184.88	184.89	183.86	184.24	13733675.0
2014-10-15 12:30:00	SPY	ETF	184.241	184.48	183.22	183.41	16638561.0
2014-10-15 13:00:00	SPY	ETF	183.41	183.89	181.92	182.29	32568778.0
2014-10-15 13:30:00	SPY	ETF	182.29	183.54	182.13	182.92	27120805.0
2014-10-15 14:00:00	SPY	ETF	182.92	184.06	182.45	183.64	30093849.0
2014-10-15 14:30:00	SPY	ETF	183.64	187.694	183.46	184.74	21773223.0
2014-10-15 15:00:00	SPY	ETF	184.72	185.9	184.21	185.83	31971320.0
2014-10-15 15:30:00	SPY	ETF	185.83	186.88	185.54	186.29	43909889.0
2014-10-15 16:00:00	SPY	ETF	186.33	187.694	183.905	185.28	12536168.0
2014-10-15 16:30:00	SPY	ETF	185.25	186.6414	184.9	185.12	2200804.0
2014-10-15 17:00:00	SPY	ETF	185.12	185.21	185.04	185.18	1240633.0
2014-10-15 17:30:00	SPY	ETF	185.15	185.23	185.0	185.15	289609.0
2014-10-15 18:00:00	SPY	ETF	185.19	185.38	185.1	185.13	243156.0
2014-10-15 18:30:00	SPY	ETF	185.11	185.35	184.81	185.12	86422.0
2014-10-15 19:00:00	SPY	ETF	185.11	185.11	184.92	185.08	58999.0
2014-10-15 19:30:00	SPY	ETF	185.06	185.45	185.03	185.25	79587.0
2014-10-15 04:00:00	QQQ	ETF	92.99	93.0	92.97	92.97	12700.0
2014-10-15 04:30:00	QQQ	ETF	92.95	92.98	92.95	92.98	7600.0
2014-10-15 05:00:00	QQQ	ETF	92.98	93.01	92.89	92.89	10000.0
2014-10-15 05:30:00	QQQ	ETF	93.01	93.08	92.98	93.08	300.0
2014-10-15 06:00:00	QQQ	ETF	93.1	93.2	93.1	93.1	18300.0
2014-10-15 06:30:00	QQQ	ETF	93.15	93.2	93.05	93.06	7897.0
2014-10-15 07:00:00	QQQ	ETF	93.13	93.13	92.52	92.53	110810.0
2014-10-15 07:30:00	QQQ	ETF	92.53	92.67	92.4	92.4	163499.0
2014-10-15 08:00:00	QQQ	ETF	92.44	93.12	92.36	92.73	279117.0
2014-10-15 08:30:00	QQQ	ETF	92.69	92.69	91.95	92.0	1002994.0
2014-10-15 09:00:00	QQQ	ETF	92.0	92.15	91.55	91.55	1384497.0
2014-10-15 09:30:00	QQQ	ETF	91.55	92.26	91.19	92.03	16612889.0
2014-10-15 10:00:00	QQQ	ETF	92.02	92.519	91.95	91.97	9585158.0
2014-10-15 10:30:00	QQQ	ETF	91.97	92.26	91.75	91.97	6075115.0
2014-10-15 11:00:00	QQQ	ETF	91.96	92.43	91.6	91.66	5384662.0
2014-10-15 11:30:00	QQQ	ETF	91.65	91.9	91.35	91.75	4062887.0
2014-10-15 12:00:00	QQQ	ETF	91.7442	91.7442	91.28	91.39	3357614.0
2014-10-15 12:30:00	QQQ	ETF	91.4	91.5	90.82	90.99	5937444.0

> showing 50 of 13,502 rows — these rows as CSV

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