PREVIEW / etf_30min / 2009-07-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-06.parquet
  size:    218 KB
  rows:    7,229

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
2009-07-06 04:00:00	SPY	ETF	88.88	89.07	88.88	89.07	2826.0
2009-07-06 04:30:00	SPY	ETF	88.93	88.95	88.89	88.92	1100.0
2009-07-06 05:00:00	SPY	ETF	88.92	89.03	88.92	89.01	1300.0
2009-07-06 05:30:00	SPY	ETF	88.92	88.92	88.88	88.88	2600.0
2009-07-06 06:00:00	SPY	ETF	88.89	88.91	88.81	88.88	30300.0
2009-07-06 06:30:00	SPY	ETF	88.86	88.89	88.71	88.76	20500.0
2009-07-06 07:00:00	SPY	ETF	88.79	89.06	88.78	89.05	302009.0
2009-07-06 07:30:00	SPY	ETF	89.05	89.05	88.85	89.03	202878.0
2009-07-06 08:00:00	SPY	ETF	89.03	89.53	88.95	89.1	1347297.0
2009-07-06 08:30:00	SPY	ETF	89.1	90.0	88.97	89.07	1201222.0
2009-07-06 09:00:00	SPY	ETF	89.08	89.6752	88.92	88.94	1815758.0
2009-07-06 09:30:00	SPY	ETF	88.94	89.5602	88.86	89.45	22992965.0
2009-07-06 10:00:00	SPY	ETF	89.445	89.67	88.77	88.85	24556856.0
2009-07-06 10:30:00	SPY	ETF	88.84	88.92	88.66	88.8899	15347515.0
2009-07-06 11:00:00	SPY	ETF	88.89	89.17	88.87	89.08	8494869.0
2009-07-06 11:30:00	SPY	ETF	89.08	89.27	88.99	89.04	7572852.0
2009-07-06 12:00:00	SPY	ETF	89.0325	89.25	89.03	89.11	5775516.0
2009-07-06 12:30:00	SPY	ETF	89.11	89.19	88.96	89.14	4861065.0
2009-07-06 13:00:00	SPY	ETF	89.14	89.59	89.14	89.48	9671635.0
2009-07-06 13:30:00	SPY	ETF	89.48	89.6752	89.29	89.385	9564352.0
2009-07-06 14:00:00	SPY	ETF	89.39	89.56	89.3	89.4	5923922.0
2009-07-06 14:30:00	SPY	ETF	89.41	89.51	89.32	89.44	5517121.0
2009-07-06 15:00:00	SPY	ETF	89.44	89.64	89.38	89.47	10237007.0
2009-07-06 15:30:00	SPY	ETF	89.47	89.93	89.2	89.9	25155720.0
2009-07-06 16:00:00	SPY	ETF	89.9	90.08	89.78	90.04	6402094.0
2009-07-06 16:30:00	SPY	ETF	90.03	90.05	89.95	89.99	2523876.0
2009-07-06 17:00:00	SPY	ETF	89.99	90.03	89.98	89.98	67334.0
2009-07-06 17:30:00	SPY	ETF	89.98	89.98	89.9	89.98	166035.0
2009-07-06 18:00:00	SPY	ETF	89.98	90.02	89.97	89.98	57882.0
2009-07-06 18:30:00	SPY	ETF	89.98	89.98	89.95	89.96	12080.0
2009-07-06 19:00:00	SPY	ETF	89.99	90.0	89.91	89.94	3855750.0
2009-07-06 19:30:00	SPY	ETF	89.91	89.98	89.9	89.98	35756.0
2009-07-06 04:00:00	QQQ	ETF	35.32	35.32	35.32	35.32	400.0
2009-07-06 04:30:00	QQQ	ETF	35.3	35.3	35.3	35.3	900.0
2009-07-06 05:30:00	QQQ	ETF	35.3	35.3	35.3	35.3	300.0
2009-07-06 06:30:00	QQQ	ETF	35.28	35.28	35.24	35.25	2700.0
2009-07-06 07:00:00	QQQ	ETF	35.26	35.37	35.26	35.36	416075.0
2009-07-06 07:30:00	QQQ	ETF	35.33	35.36	35.31	35.36	71840.0
2009-07-06 08:00:00	QQQ	ETF	35.36	35.42	35.15	35.41	568000.0
2009-07-06 08:30:00	QQQ	ETF	35.42	35.46	35.4	35.43	418109.0
2009-07-06 09:00:00	QQQ	ETF	35.43	35.43	35.38	35.39	423182.0
2009-07-06 09:30:00	QQQ	ETF	35.38	35.54	35.26	35.37	15031919.0
2009-07-06 10:00:00	QQQ	ETF	35.38	35.47	35.04	35.11	17764978.0
2009-07-06 10:30:00	QQQ	ETF	35.11	35.1899	35.06	35.17	8897545.0
2009-07-06 11:00:00	QQQ	ETF	35.17	35.22	35.13	35.1901	4359323.0
2009-07-06 11:30:00	QQQ	ETF	35.2	35.21	35.1	35.11	4897371.0
2009-07-06 12:00:00	QQQ	ETF	35.11	35.2	35.1	35.13	2624973.0
2009-07-06 12:30:00	QQQ	ETF	35.13	35.15	35.08	35.125	3733096.0
2009-07-06 13:00:00	QQQ	ETF	35.13	35.3	35.12	35.24	7029863.0
2009-07-06 13:30:00	QQQ	ETF	35.24	35.24	35.16	35.19	3263136.0

> showing 50 of 7,229 rows — these rows as CSV

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