PREVIEW / etf_30min / 2014-01-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-14.parquet
  size:    343 KB
  rows:    11,349

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-14 04:00:00	SPY	ETF	182.08	182.1	182.04	182.08	9388.0
2014-01-14 04:30:00	SPY	ETF	182.1	182.15	182.0	182.0	34542.0
2014-01-14 05:00:00	SPY	ETF	181.97	182.05	181.97	182.03	17803.0
2014-01-14 05:30:00	SPY	ETF	182.03	182.05	182.0	182.05	12700.0
2014-01-14 06:00:00	SPY	ETF	182.05	182.1	182.04	182.05	9261.0
2014-01-14 06:30:00	SPY	ETF	182.15	182.2	182.12	182.12	89969.0
2014-01-14 07:00:00	SPY	ETF	182.14	182.18	181.99	182.18	129839.0
2014-01-14 07:30:00	SPY	ETF	182.19	182.28	182.19	182.24	174903.0
2014-01-14 08:00:00	SPY	ETF	182.21	182.28	182.04	182.08	257920.0
2014-01-14 08:30:00	SPY	ETF	182.09	182.37	182.08	182.34	1216210.0
2014-01-14 09:00:00	SPY	ETF	182.35	182.35	182.21	182.28	709327.0
2014-01-14 09:30:00	SPY	ETF	182.28	182.56	181.95	182.17	13497322.0
2014-01-14 10:00:00	SPY	ETF	182.165	182.635	182.16	182.5	8156278.0
2014-01-14 10:30:00	SPY	ETF	182.5	182.93	182.45	182.87	6328345.0
2014-01-14 11:00:00	SPY	ETF	182.87	183.27	182.8	183.05	7803961.0
2014-01-14 11:30:00	SPY	ETF	183.05	183.18	183.01	183.125	3900891.0
2014-01-14 12:00:00	SPY	ETF	183.125	183.49	183.07	183.39	4530240.0
2014-01-14 12:30:00	SPY	ETF	183.39	183.57	183.3	183.32	4573256.0
2014-01-14 13:00:00	SPY	ETF	183.32	183.53	183.26	183.34	4803846.0
2014-01-14 13:30:00	SPY	ETF	183.34	183.6	183.28	183.37	4230186.0
2014-01-14 14:00:00	SPY	ETF	183.36	183.47	183.21	183.47	8212171.0
2014-01-14 14:30:00	SPY	ETF	183.48	183.63	183.41	183.46	3939915.0
2014-01-14 15:00:00	SPY	ETF	183.47	183.76	183.42	183.73	4718264.0
2014-01-14 15:30:00	SPY	ETF	183.735	183.77	183.48	183.68	11038398.0
2014-01-14 16:00:00	SPY	ETF	183.68	183.72	181.7411	183.66	4617013.0
2014-01-14 16:30:00	SPY	ETF	183.66	183.66	182.7578	183.62	548731.0
2014-01-14 17:00:00	SPY	ETF	183.65	183.7	183.65	183.69	2016974.0
2014-01-14 17:30:00	SPY	ETF	183.69	183.71	183.68	183.71	11164.0
2014-01-14 18:00:00	SPY	ETF	183.68	183.76	183.58	183.74	900339.0
2014-01-14 18:30:00	SPY	ETF	183.76	183.76	183.69	183.7	42250.0
2014-01-14 19:00:00	SPY	ETF	183.68	183.7	183.63	183.67	40170.0
2014-01-14 19:30:00	SPY	ETF	183.66	183.66	183.63	183.66	83360.0
2014-01-14 04:00:00	QQQ	ETF	86.14	86.17	86.14	86.17	2200.0
2014-01-14 04:30:00	QQQ	ETF	86.2	86.2	86.2	86.2	300.0
2014-01-14 05:00:00	QQQ	ETF	86.11	86.11	86.11	86.11	2500.0
2014-01-14 06:00:00	QQQ	ETF	86.18	86.18	86.16	86.16	680.0
2014-01-14 06:30:00	QQQ	ETF	86.14	86.18	86.14	86.17	300.0
2014-01-14 07:00:00	QQQ	ETF	86.15	86.23	86.14	86.23	19525.0
2014-01-14 07:30:00	QQQ	ETF	86.28	86.28	86.27	86.28	34500.0
2014-01-14 08:00:00	QQQ	ETF	86.28	86.3	86.19	86.19	26121.0
2014-01-14 08:30:00	QQQ	ETF	86.27	86.35	86.25	86.34	51908.0
2014-01-14 09:00:00	QQQ	ETF	86.33	86.34	86.285	86.3	115760.0
2014-01-14 09:30:00	QQQ	ETF	86.3	86.51	86.3	86.451	4795319.0
2014-01-14 10:00:00	QQQ	ETF	86.45	86.8	86.45	86.75	4027630.0
2014-01-14 10:30:00	QQQ	ETF	86.76	87.06	86.71	87.05	3509401.0
2014-01-14 11:00:00	QQQ	ETF	87.05	87.2901	87.05	87.23	3399067.0
2014-01-14 11:30:00	QQQ	ETF	87.22	87.33	87.18	87.29	1476310.0
2014-01-14 12:00:00	QQQ	ETF	87.3	87.53	87.26	87.5001	2190735.0
2014-01-14 12:30:00	QQQ	ETF	87.51	87.62	87.43	87.5	2663718.0
2014-01-14 13:00:00	QQQ	ETF	87.5	87.64	87.47	87.53	1827588.0

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

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