PREVIEW / etf_30min / 2014-08-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-22.parquet
  size:    332 KB
  rows:    11,307

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-08-22 04:00:00	SPY	ETF	199.64	199.66	199.62	199.66	2864.0
2014-08-22 04:30:00	SPY	ETF	199.59	199.65	199.57	199.57	1828.0
2014-08-22 05:00:00	SPY	ETF	199.58	199.58	199.43	199.43	651.0
2014-08-22 05:30:00	SPY	ETF	199.42	199.49	199.42	199.49	28555.0
2014-08-22 06:00:00	SPY	ETF	199.4	199.44	198.92	198.98	98665.0
2014-08-22 06:30:00	SPY	ETF	198.91	199.3	198.9	199.27	20705.0
2014-08-22 07:00:00	SPY	ETF	199.28	199.33	199.19	199.33	112800.0
2014-08-22 07:30:00	SPY	ETF	199.3	199.55	199.22	199.48	105701.0
2014-08-22 08:00:00	SPY	ETF	199.22	199.52	199.22	199.4	138794.0
2014-08-22 08:30:00	SPY	ETF	199.41	199.42	199.14	199.34	231477.0
2014-08-22 09:00:00	SPY	ETF	199.34	199.39	199.23	199.33	220414.0
2014-08-22 09:30:00	SPY	ETF	199.34	199.46	199.0	199.31	7231561.0
2014-08-22 10:00:00	SPY	ETF	199.31	199.69	199.06	199.48	9935072.0
2014-08-22 10:30:00	SPY	ETF	199.48	199.67	198.825	198.9	7059650.0
2014-08-22 11:00:00	SPY	ETF	198.88	199.38	198.74	199.32	7400936.0
2014-08-22 11:30:00	SPY	ETF	199.32	199.37	199.11	199.24	2626009.0
2014-08-22 12:00:00	SPY	ETF	199.255	199.555	199.16	199.5	3996144.0
2014-08-22 12:30:00	SPY	ETF	199.51	199.56	199.41	199.43	1941371.0
2014-08-22 13:00:00	SPY	ETF	199.4201	199.53	199.37	199.48	1650598.0
2014-08-22 13:30:00	SPY	ETF	199.49	199.56	199.4	199.45	2218726.0
2014-08-22 14:00:00	SPY	ETF	199.4479	199.46	199.27	199.27	2878704.0
2014-08-22 14:30:00	SPY	ETF	199.265	199.37	199.05	199.28	4149671.0
2014-08-22 15:00:00	SPY	ETF	199.27	199.54	199.25	199.3725	3083589.0
2014-08-22 15:30:00	SPY	ETF	199.3731	199.38	199.04	199.16	12625530.0
2014-08-22 16:00:00	SPY	ETF	199.17	199.5422	199.148	199.38	6810849.0
2014-08-22 16:30:00	SPY	ETF	199.39	199.42	199.35	199.36	849428.0
2014-08-22 17:00:00	SPY	ETF	199.35	199.42	199.34	199.42	42735.0
2014-08-22 17:30:00	SPY	ETF	199.41	199.41	199.3	199.39	16928.0
2014-08-22 18:00:00	SPY	ETF	199.35	199.35	199.26	199.3	16007.0
2014-08-22 18:30:00	SPY	ETF	199.3	199.3	199.27	199.3	4172.0
2014-08-22 19:00:00	SPY	ETF	199.29	199.3	199.29	199.3	2200.0
2014-08-22 19:30:00	SPY	ETF	199.29	199.36	199.28	199.35	14907.0
2014-08-22 04:30:00	QQQ	ETF	98.96	98.96	98.96	98.96	5000.0
2014-08-22 05:00:00	QQQ	ETF	98.85	98.86	98.85	98.86	6500.0
2014-08-22 05:30:00	QQQ	ETF	98.83	98.88	98.83	98.88	4100.0
2014-08-22 06:00:00	QQQ	ETF	98.87	98.87	98.68	98.68	27899.0
2014-08-22 06:30:00	QQQ	ETF	98.77	98.81	98.77	98.81	4250.0
2014-08-22 07:00:00	QQQ	ETF	98.84	98.84	98.8	98.84	125600.0
2014-08-22 07:30:00	QQQ	ETF	98.81	98.92	98.8	98.92	60621.0
2014-08-22 08:00:00	QQQ	ETF	98.81	98.94	98.8	98.93	107305.0
2014-08-22 08:30:00	QQQ	ETF	98.91	98.92	98.82	98.91	91953.0
2014-08-22 09:00:00	QQQ	ETF	98.92	98.96	98.88	98.95	122210.0
2014-08-22 09:30:00	QQQ	ETF	98.94	99.03	98.72	98.955	2508893.0
2014-08-22 10:00:00	QQQ	ETF	98.95	99.11	98.8	99.1	3121056.0
2014-08-22 10:30:00	QQQ	ETF	99.11	99.23	98.8	98.85	2671755.0
2014-08-22 11:00:00	QQQ	ETF	98.84	99.105	98.76	99.1	2058474.0
2014-08-22 11:30:00	QQQ	ETF	99.09	99.14	99.01	99.08	1012247.0
2014-08-22 12:00:00	QQQ	ETF	99.08	99.25	99.031	99.2001	949240.0
2014-08-22 12:30:00	QQQ	ETF	99.21	99.24	99.17	99.17	1203221.0
2014-08-22 13:00:00	QQQ	ETF	99.18	99.19	99.08	99.155	638045.0

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

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