PREVIEW / etf_30min / 2010-04-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-14.parquet
  size:    260 KB
  rows:    8,606

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
2010-04-14 04:00:00	SPY	ETF	120.0	120.0	120.0	120.0	1600.0
2010-04-14 04:30:00	SPY	ETF	120.1	120.1	120.1	120.1	2000.0
2010-04-14 05:00:00	SPY	ETF	120.08	120.08	120.08	120.08	2700.0
2010-04-14 05:30:00	SPY	ETF	120.05	120.05	120.05	120.05	200.0
2010-04-14 06:00:00	SPY	ETF	120.04	120.08	120.04	120.08	1150.0
2010-04-14 06:30:00	SPY	ETF	120.1	120.2	120.06	120.2	128000.0
2010-04-14 07:00:00	SPY	ETF	120.16	120.23	120.12	120.23	242200.0
2010-04-14 07:30:00	SPY	ETF	120.23	120.32	120.19	120.31	632350.0
2010-04-14 08:00:00	SPY	ETF	120.31	120.36	120.18	120.36	1113287.0
2010-04-14 08:30:00	SPY	ETF	120.36	120.49	120.24	120.25	1525522.0
2010-04-14 09:00:00	SPY	ETF	120.25	120.32	120.22	120.29	1332012.0
2010-04-14 09:30:00	SPY	ETF	120.27	120.54	120.23	120.31	22627443.0
2010-04-14 10:00:00	SPY	ETF	120.31	120.41	120.08	120.31	19764553.0
2010-04-14 10:30:00	SPY	ETF	120.32	120.49	120.21	120.46	13966218.0
2010-04-14 11:00:00	SPY	ETF	120.46	120.65	120.25	120.64	10866671.0
2010-04-14 11:30:00	SPY	ETF	120.63	120.64	120.51	120.56	6688749.0
2010-04-14 12:00:00	SPY	ETF	120.55	120.68	120.53	120.6682	5293161.0
2010-04-14 12:30:00	SPY	ETF	120.67	120.78	120.6	120.72	5501393.0
2010-04-14 13:00:00	SPY	ETF	120.7201	120.87	120.7	120.86	4684332.0
2010-04-14 13:30:00	SPY	ETF	120.86	120.89	120.63	120.64	9355343.0
2010-04-14 14:00:00	SPY	ETF	120.64	120.86	120.64	120.86	7073947.0
2010-04-14 14:30:00	SPY	ETF	120.86	120.95	120.7	120.92	8363543.0
2010-04-14 15:00:00	SPY	ETF	120.921	120.95	120.83	120.94	6621935.0
2010-04-14 15:30:00	SPY	ETF	120.95	121.19	120.89	121.17	20341046.0
2010-04-14 16:00:00	SPY	ETF	121.18	121.19	120.2	121.12	7811069.0
2010-04-14 16:30:00	SPY	ETF	121.12	121.23	121.12	121.16	5275125.0
2010-04-14 17:00:00	SPY	ETF	121.18	121.19	121.12	121.13	176854.0
2010-04-14 17:30:00	SPY	ETF	121.16	121.24	121.16	121.18	405810.0
2010-04-14 18:00:00	SPY	ETF	121.16	121.16	121.14	121.14	756832.0
2010-04-14 18:30:00	SPY	ETF	121.15	121.17	121.11	121.14	390390.0
2010-04-14 19:00:00	SPY	ETF	121.12	121.15	121.11	121.15	5533.0
2010-04-14 19:30:00	SPY	ETF	121.12	121.16	121.12	121.16	27604.0
2010-04-14 04:00:00	QQQ	ETF	49.48	49.49	49.48	49.49	2500.0
2010-04-14 06:00:00	QQQ	ETF	49.51	49.51	49.51	49.51	800.0
2010-04-14 06:30:00	QQQ	ETF	49.52	49.52	49.52	49.52	1000.0
2010-04-14 07:00:00	QQQ	ETF	49.55	49.56	49.52	49.55	135492.0
2010-04-14 07:30:00	QQQ	ETF	49.55	49.58	49.53	49.58	53071.0
2010-04-14 08:00:00	QQQ	ETF	49.58	49.6	49.54	49.6	267532.0
2010-04-14 08:30:00	QQQ	ETF	49.6	49.65	49.56	49.57	642290.0
2010-04-14 09:00:00	QQQ	ETF	49.57	49.6	49.55	49.56	942334.0
2010-04-14 09:30:00	QQQ	ETF	49.57	49.65	49.5	49.59	9559217.0
2010-04-14 10:00:00	QQQ	ETF	49.6	49.65	49.51	49.5701	10559344.0
2010-04-14 10:30:00	QQQ	ETF	49.58	49.64	49.51	49.62	6047768.0
2010-04-14 11:00:00	QQQ	ETF	49.62	49.69	49.58	49.6681	3953312.0
2010-04-14 11:30:00	QQQ	ETF	49.66	49.7	49.64	49.66	1830953.0
2010-04-14 12:00:00	QQQ	ETF	49.66	49.71	49.65	49.7099	2404945.0
2010-04-14 12:30:00	QQQ	ETF	49.71	49.74	49.7	49.725	2122532.0
2010-04-14 13:00:00	QQQ	ETF	49.73	49.79	49.72	49.7899	1879030.0
2010-04-14 13:30:00	QQQ	ETF	49.79	49.8	49.68	49.68	1433215.0
2010-04-14 14:00:00	QQQ	ETF	49.68	49.775	49.68	49.77	2240478.0

> showing 50 of 8,606 rows — these rows as CSV

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