PREVIEW / etf_30min / 2013-09-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-23.parquet
  size:    320 KB
  rows:    10,720

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-09-23 04:00:00	SPY	ETF	171.04	171.17	171.04	171.17	900.0
2013-09-23 04:30:00	SPY	ETF	171.1	171.1	171.02	171.02	800.0
2013-09-23 05:00:00	SPY	ETF	170.99	171.0	170.87	170.9	26276.0
2013-09-23 05:30:00	SPY	ETF	170.87	170.94	170.87	170.9	6100.0
2013-09-23 06:00:00	SPY	ETF	170.92	170.96	170.92	170.96	2750.0
2013-09-23 06:30:00	SPY	ETF	170.95	170.95	170.9	170.9	37850.0
2013-09-23 07:00:00	SPY	ETF	170.87	170.87	170.55	170.59	52180.0
2013-09-23 07:30:00	SPY	ETF	170.6	170.63	170.28	170.32	249330.0
2013-09-23 08:00:00	SPY	ETF	170.29	171.05	170.25	170.39	405427.0
2013-09-23 08:30:00	SPY	ETF	170.4	170.48	170.22	170.41	724301.0
2013-09-23 09:00:00	SPY	ETF	170.42	170.5	170.17	170.49	942256.0
2013-09-23 09:30:00	SPY	ETF	170.49	170.65	170.06	170.09	13391135.0
2013-09-23 10:00:00	SPY	ETF	170.09	170.2	169.85	169.89	9764702.0
2013-09-23 10:30:00	SPY	ETF	169.89	170.05	169.52	169.6	8896265.0
2013-09-23 11:00:00	SPY	ETF	169.61	169.7278	169.39	169.63	8026340.0
2013-09-23 11:30:00	SPY	ETF	169.64	169.82	169.59	169.63	7026439.0
2013-09-23 12:00:00	SPY	ETF	169.635	169.93	169.62	169.9	3548449.0
2013-09-23 12:30:00	SPY	ETF	169.9	170.01	169.81	169.99	2989783.0
2013-09-23 13:00:00	SPY	ETF	169.99	170.04	169.76	169.92	4093921.0
2013-09-23 13:30:00	SPY	ETF	169.92	170.18	169.85	170.175	4549478.0
2013-09-23 14:00:00	SPY	ETF	170.17	170.23	169.89	169.94	6299248.0
2013-09-23 14:30:00	SPY	ETF	169.94	170.17	169.9	170.14	4283715.0
2013-09-23 15:00:00	SPY	ETF	170.14	170.15	169.8	169.81	5525164.0
2013-09-23 15:30:00	SPY	ETF	169.82	170.12	169.78	169.93	10758907.0
2013-09-23 16:00:00	SPY	ETF	169.94	169.99	169.67	169.7	9989538.0
2013-09-23 16:30:00	SPY	ETF	169.7	169.94	169.7	169.74	1121028.0
2013-09-23 17:00:00	SPY	ETF	169.75	170.033	169.74	169.79	120256.0
2013-09-23 17:30:00	SPY	ETF	169.79	169.79	169.71	169.77	20878.0
2013-09-23 18:00:00	SPY	ETF	169.74	169.82	169.74	169.79	11277.0
2013-09-23 18:30:00	SPY	ETF	169.79	169.81	169.75	169.81	8965.0
2013-09-23 19:00:00	SPY	ETF	169.78	169.78	169.74	169.74	18129.0
2013-09-23 19:30:00	SPY	ETF	169.74	169.75	169.67	169.7	43427.0
2013-09-23 04:00:00	QQQ	ETF	79.0	79.15	79.0	79.15	1500.0
2013-09-23 05:00:00	QQQ	ETF	79.15	79.16	79.1	79.1	23800.0
2013-09-23 05:30:00	QQQ	ETF	79.12	79.12	79.1	79.12	4800.0
2013-09-23 06:00:00	QQQ	ETF	79.14	79.16	79.14	79.16	3000.0
2013-09-23 06:30:00	QQQ	ETF	79.14	79.14	79.12	79.12	3200.0
2013-09-23 07:00:00	QQQ	ETF	79.1	79.1	78.98	78.98	14200.0
2013-09-23 07:30:00	QQQ	ETF	78.98	78.98	78.8	78.81	56300.0
2013-09-23 08:00:00	QQQ	ETF	79.09	79.09	78.79	78.85	74897.0
2013-09-23 08:30:00	QQQ	ETF	78.83	79.32	78.83	79.28	1387312.0
2013-09-23 09:00:00	QQQ	ETF	79.28	79.35	79.19	79.34	612232.0
2013-09-23 09:30:00	QQQ	ETF	79.34	79.41	79.005	79.02	4469884.0
2013-09-23 10:00:00	QQQ	ETF	79.02	79.05	78.76	78.86	3189780.0
2013-09-23 10:30:00	QQQ	ETF	78.85	78.9	78.591	78.63	2478471.0
2013-09-23 11:00:00	QQQ	ETF	78.63	78.67	78.455	78.57	2736053.0
2013-09-23 11:30:00	QQQ	ETF	78.5736	78.71	78.55	78.55	1022300.0
2013-09-23 12:00:00	QQQ	ETF	78.55	78.8	78.54	78.73	1055781.0
2013-09-23 12:30:00	QQQ	ETF	78.7386	78.87	78.68	78.859	943165.0
2013-09-23 13:00:00	QQQ	ETF	78.85	78.88	78.72	78.82	856782.0

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

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