PREVIEW / etf_30min / 2013-03-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-19.parquet
  size:    319 KB
  rows:    10,583

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-03-19 04:00:00	SPY	ETF	155.13	155.16	155.06	155.16	8700.0
2013-03-19 04:30:00	SPY	ETF	155.1	155.14	155.03	155.13	1050.0
2013-03-19 05:00:00	SPY	ETF	155.13	155.18	154.94	154.94	19051.0
2013-03-19 05:30:00	SPY	ETF	154.95	155.06	154.92	155.01	25700.0
2013-03-19 06:00:00	SPY	ETF	155.06	155.12	155.0	155.12	20500.0
2013-03-19 06:30:00	SPY	ETF	155.01	155.08	154.94	155.08	26300.0
2013-03-19 07:00:00	SPY	ETF	155.08	155.23	155.06	155.18	130420.0
2013-03-19 07:30:00	SPY	ETF	155.2	155.31	155.19	155.31	268246.0
2013-03-19 08:00:00	SPY	ETF	155.3	155.51	155.1	155.47	432463.0
2013-03-19 08:30:00	SPY	ETF	155.49	155.54	155.34	155.42	564894.0
2013-03-19 09:00:00	SPY	ETF	155.42	155.44	155.27	155.3	581439.0
2013-03-19 09:30:00	SPY	ETF	155.3	155.51	155.18	155.41	9828112.0
2013-03-19 10:00:00	SPY	ETF	155.41	155.5	154.97	155.01	8769799.0
2013-03-19 10:30:00	SPY	ETF	155.02	155.4501	154.76	155.0	10701630.0
2013-03-19 11:00:00	SPY	ETF	154.99	155.13	154.78	155.06	5898910.0
2013-03-19 11:30:00	SPY	ETF	155.06	155.16	153.98	154.115	15085470.0
2013-03-19 12:00:00	SPY	ETF	154.11	154.37	153.86	154.325	16103792.0
2013-03-19 12:30:00	SPY	ETF	154.33	154.42	154.06	154.12	7744935.0
2013-03-19 13:00:00	SPY	ETF	154.12	154.23	153.59	153.73	11053421.0
2013-03-19 13:30:00	SPY	ETF	153.715	154.03	153.61	153.95	10541530.0
2013-03-19 14:00:00	SPY	ETF	153.95	154.28	153.835	154.21	12603319.0
2013-03-19 14:30:00	SPY	ETF	154.2	154.49	154.11	154.19	9018415.0
2013-03-19 15:00:00	SPY	ETF	154.19	154.86	153.985	154.3168	21276015.0
2013-03-19 15:30:00	SPY	ETF	154.32	154.68	154.122	154.64	15936689.0
2013-03-19 16:00:00	SPY	ETF	154.63	154.72	154.24	154.62	8125900.0
2013-03-19 16:30:00	SPY	ETF	154.61	154.62	154.4	154.42	530930.0
2013-03-19 17:00:00	SPY	ETF	154.42	154.45	154.35	154.45	232400.0
2013-03-19 17:30:00	SPY	ETF	154.46	154.46	154.36	154.37	61264.0
2013-03-19 18:00:00	SPY	ETF	154.36	154.36	154.22	154.3	147254.0
2013-03-19 18:30:00	SPY	ETF	154.3	154.3	154.14	154.17	157755.0
2013-03-19 19:00:00	SPY	ETF	154.2	154.22	154.15	154.22	32200.0
2013-03-19 19:30:00	SPY	ETF	154.21	154.29	154.21	154.29	36626.0
2013-03-19 04:00:00	QQQ	ETF	68.33	68.33	68.33	68.33	8000.0
2013-03-19 04:30:00	QQQ	ETF	68.41	68.41	68.41	68.41	100.0
2013-03-19 07:00:00	QQQ	ETF	68.39	68.42	68.39	68.42	12000.0
2013-03-19 07:30:00	QQQ	ETF	68.47	68.48	68.47	68.48	26000.0
2013-03-19 08:00:00	QQQ	ETF	68.52	68.64	68.52	68.6	278000.0
2013-03-19 08:30:00	QQQ	ETF	68.62	68.64	68.58	68.6	53787.0
2013-03-19 09:00:00	QQQ	ETF	68.6	68.6	68.55	68.55	98293.0
2013-03-19 09:30:00	QQQ	ETF	68.54	68.66	68.48	68.64	2319212.0
2013-03-19 10:00:00	QQQ	ETF	68.65	68.7	68.3701	68.4	1981462.0
2013-03-19 10:30:00	QQQ	ETF	68.4	68.42	68.23	68.33	2323478.0
2013-03-19 11:00:00	QQQ	ETF	68.33	68.46	68.24	68.43	1288137.0
2013-03-19 11:30:00	QQQ	ETF	68.44	68.48	67.9	67.96	2778962.0
2013-03-19 12:00:00	QQQ	ETF	67.95	68.05	67.83	68.01	1982880.0
2013-03-19 12:30:00	QQQ	ETF	68.02	68.0699	67.91	67.94	918462.0
2013-03-19 13:00:00	QQQ	ETF	67.93	67.9901	67.62	67.7	2808026.0
2013-03-19 13:30:00	QQQ	ETF	67.7	67.85	67.645	67.82	2704440.0
2013-03-19 14:00:00	QQQ	ETF	67.82	67.98	67.7841	67.98	2121883.0
2013-03-19 14:30:00	QQQ	ETF	67.99	68.08	67.89	67.9497	1377805.0

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

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