PREVIEW / etf_30min / 2014-01-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-03.parquet
  size:    339 KB
  rows:    11,359

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-01-03 04:00:00	SPY	ETF	182.88	183.0	182.78	182.98	19825.0
2014-01-03 04:30:00	SPY	ETF	182.97	183.03	182.97	183.03	10500.0
2014-01-03 05:00:00	SPY	ETF	183.13	183.13	183.08	183.12	3565.0
2014-01-03 05:30:00	SPY	ETF	183.13	183.13	183.07	183.07	600.0
2014-01-03 06:30:00	SPY	ETF	183.02	183.13	183.02	183.02	11781.0
2014-01-03 07:00:00	SPY	ETF	183.03	183.11	183.03	183.11	25313.0
2014-01-03 07:30:00	SPY	ETF	183.13	183.33	183.13	183.28	114255.0
2014-01-03 08:00:00	SPY	ETF	183.24	183.48	183.08	183.38	525012.0
2014-01-03 08:30:00	SPY	ETF	183.39	183.39	183.24	183.28	348270.0
2014-01-03 09:00:00	SPY	ETF	183.3	183.33	183.16	183.2	282250.0
2014-01-03 09:30:00	SPY	ETF	183.21	183.53	183.1	183.455	7543246.0
2014-01-03 10:00:00	SPY	ETF	183.45	183.6	183.3	183.39	5697644.0
2014-01-03 10:30:00	SPY	ETF	183.39	183.53	183.23	183.3518	3793770.0
2014-01-03 11:00:00	SPY	ETF	183.35	183.44	182.9	182.9299	5475830.0
2014-01-03 11:30:00	SPY	ETF	182.92	182.98	182.68	182.74	5720925.0
2014-01-03 12:00:00	SPY	ETF	182.735	182.89	182.63	182.8716	5325090.0
2014-01-03 12:30:00	SPY	ETF	182.879	183.0	182.85	182.87	4146283.0
2014-01-03 13:00:00	SPY	ETF	182.87	182.96	182.79	182.8899	3453386.0
2014-01-03 13:30:00	SPY	ETF	182.88	182.88	182.69	182.83	1924983.0
2014-01-03 14:00:00	SPY	ETF	182.83	182.95	182.8	182.915	3783134.0
2014-01-03 14:30:00	SPY	ETF	182.92	183.32	182.85	183.2	6172451.0
2014-01-03 15:00:00	SPY	ETF	183.2	183.5	183.14	183.36	6136620.0
2014-01-03 15:30:00	SPY	ETF	183.36	183.44	182.78	182.8	13024974.0
2014-01-03 16:00:00	SPY	ETF	182.8	183.1818	182.8	182.85	5742152.0
2014-01-03 16:30:00	SPY	ETF	182.84	182.88	182.67	182.69	1222405.0
2014-01-03 17:00:00	SPY	ETF	182.67	183.1323	182.63	182.63	198657.0
2014-01-03 17:30:00	SPY	ETF	182.63	182.67	182.62	182.66	32218.0
2014-01-03 18:00:00	SPY	ETF	182.67	182.69	182.62	182.65	14823.0
2014-01-03 18:30:00	SPY	ETF	182.68	182.7	182.65	182.67	4669.0
2014-01-03 19:00:00	SPY	ETF	182.7	182.7	182.7	182.7	4300.0
2014-01-03 19:30:00	SPY	ETF	182.7	182.7	182.62	182.66	8099.0
2014-01-03 06:00:00	QQQ	ETF	87.28	87.28	87.27	87.27	2309.0
2014-01-03 06:30:00	QQQ	ETF	87.28	87.28	87.28	87.28	200.0
2014-01-03 07:00:00	QQQ	ETF	87.29	87.29	87.29	87.29	200.0
2014-01-03 07:30:00	QQQ	ETF	87.34	87.37	87.34	87.36	19700.0
2014-01-03 08:00:00	QQQ	ETF	87.38	87.43	87.15	87.39	48312.0
2014-01-03 08:30:00	QQQ	ETF	87.36	87.36	87.29	87.33	37547.0
2014-01-03 09:00:00	QQQ	ETF	87.35	87.35	87.25	87.25	35057.0
2014-01-03 09:30:00	QQQ	ETF	87.27	87.35	87.12	87.27	2830970.0
2014-01-03 10:00:00	QQQ	ETF	87.26	87.32	87.1	87.14	1174860.0
2014-01-03 10:30:00	QQQ	ETF	87.135	87.225	86.985	87.04	1976771.0
2014-01-03 11:00:00	QQQ	ETF	87.04	87.055	86.8	86.809	2973589.0
2014-01-03 11:30:00	QQQ	ETF	86.8	86.845	86.6228	86.65	2657839.0
2014-01-03 12:00:00	QQQ	ETF	86.65	87.2623	86.62	86.6976	1742962.0
2014-01-03 12:30:00	QQQ	ETF	86.6903	86.778	86.66	86.7101	976337.0
2014-01-03 13:00:00	QQQ	ETF	86.71	86.76	86.66	86.72	749932.0
2014-01-03 13:30:00	QQQ	ETF	86.72	86.75	86.66	86.73	438820.0
2014-01-03 14:00:00	QQQ	ETF	86.74	86.778	86.7	86.76	655108.0
2014-01-03 14:30:00	QQQ	ETF	86.76	86.955	86.73	86.89	1403836.0
2014-01-03 15:00:00	QQQ	ETF	86.89	86.96	86.83	86.938	1838607.0

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

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