PREVIEW / etf_30min / 2014-04-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-15.parquet
  size:    352 KB
  rows:    11,659

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-04-15 04:00:00	SPY	ETF	183.04	183.04	182.82	182.93	9184.0
2014-04-15 04:30:00	SPY	ETF	182.92	183.03	182.87	182.87	10916.0
2014-04-15 05:00:00	SPY	ETF	182.92	183.01	182.79	182.79	12130.0
2014-04-15 05:30:00	SPY	ETF	182.82	182.94	182.78	182.94	55144.0
2014-04-15 06:00:00	SPY	ETF	182.94	183.1	182.93	183.01	72546.0
2014-04-15 06:30:00	SPY	ETF	183.05	183.2	183.05	183.11	35850.0
2014-04-15 07:00:00	SPY	ETF	183.07	183.41	183.05	183.37	117395.0
2014-04-15 07:30:00	SPY	ETF	183.35	183.48	183.25	183.45	129782.0
2014-04-15 08:00:00	SPY	ETF	183.45	183.69	183.11	183.63	253262.0
2014-04-15 08:30:00	SPY	ETF	183.59	183.59	183.26	183.4	685399.0
2014-04-15 09:00:00	SPY	ETF	183.38	183.48	183.29	183.31	302027.0
2014-04-15 09:30:00	SPY	ETF	183.32	184.29	183.15	184.1	16625715.0
2014-04-15 10:00:00	SPY	ETF	184.095	184.25	182.87	182.94	15676380.0
2014-04-15 10:30:00	SPY	ETF	182.93	183.355	182.58	182.76	13849645.0
2014-04-15 11:00:00	SPY	ETF	182.76	182.92	182.29	182.7379	13491589.0
2014-04-15 11:30:00	SPY	ETF	182.739	183.16	182.04	182.2499	10525953.0
2014-04-15 12:00:00	SPY	ETF	182.25	182.25	181.79	182.17	8504621.0
2014-04-15 12:30:00	SPY	ETF	182.17	182.21	181.62	181.67	7604622.0
2014-04-15 13:00:00	SPY	ETF	181.66	182.21	181.51	182.21	7639480.0
2014-04-15 13:30:00	SPY	ETF	182.21	183.0	182.09	182.93	8863910.0
2014-04-15 14:00:00	SPY	ETF	182.94	183.35	182.88	183.16	10207822.0
2014-04-15 14:30:00	SPY	ETF	183.16	184.05	183.11	183.73	10612911.0
2014-04-15 15:00:00	SPY	ETF	183.7299	184.29	183.49	184.22	9725653.0
2014-04-15 15:30:00	SPY	ETF	184.21	184.33	183.81	184.23	14599244.0
2014-04-15 16:00:00	SPY	ETF	184.24	184.56	182.9698	184.45	5435703.0
2014-04-15 16:30:00	SPY	ETF	184.49	184.87	184.49	184.86	777584.0
2014-04-15 17:00:00	SPY	ETF	184.85	184.94	184.82	184.87	166076.0
2014-04-15 17:30:00	SPY	ETF	184.85	184.88	184.76	184.78	76220.0
2014-04-15 18:00:00	SPY	ETF	184.79	184.85	184.72	184.73	73137.0
2014-04-15 18:30:00	SPY	ETF	184.73	184.75	184.68	184.69	15262.0
2014-04-15 19:00:00	SPY	ETF	184.67	184.71	184.67	184.68	19350.0
2014-04-15 19:30:00	SPY	ETF	184.68	184.7	184.66	184.66	75610.0
2014-04-15 04:00:00	QQQ	ETF	84.88	84.88	84.77	84.77	6000.0
2014-04-15 05:00:00	QQQ	ETF	84.76	84.76	84.76	84.76	10000.0
2014-04-15 05:30:00	QQQ	ETF	84.75	84.84	84.74	84.83	45100.0
2014-04-15 06:00:00	QQQ	ETF	84.85	84.94	84.83	84.83	68161.0
2014-04-15 06:30:00	QQQ	ETF	84.92	85.01	84.92	84.98	58303.0
2014-04-15 07:00:00	QQQ	ETF	84.95	85.13	84.93	85.13	50968.0
2014-04-15 07:30:00	QQQ	ETF	85.11	85.14	85.05	85.14	2750.0
2014-04-15 08:00:00	QQQ	ETF	85.12	85.2	85.01	85.19	100878.0
2014-04-15 08:30:00	QQQ	ETF	85.2	85.2	84.97	85.11	215327.0
2014-04-15 09:00:00	QQQ	ETF	85.12	85.16	85.01	85.06	208577.0
2014-04-15 09:30:00	QQQ	ETF	85.06	85.54	84.9	85.24	7466502.0
2014-04-15 10:00:00	QQQ	ETF	85.23	85.4	84.41	84.48	6550060.0
2014-04-15 10:30:00	QQQ	ETF	84.47	84.66	84.03	84.13	6792609.0
2014-04-15 11:00:00	QQQ	ETF	84.12	84.33	83.85	84.12	6983686.0
2014-04-15 11:30:00	QQQ	ETF	84.12	84.38	83.67	83.79	4727191.0
2014-04-15 12:00:00	QQQ	ETF	83.77	83.86	83.52	83.73	7653695.0
2014-04-15 12:30:00	QQQ	ETF	83.72	83.75	83.31	83.34	3613929.0
2014-04-15 13:00:00	QQQ	ETF	83.33	83.77	83.28	83.7696	4082360.0

> showing 50 of 11,659 rows — these rows as CSV

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