PREVIEW / etf_30min / 2010-04-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-29.parquet
  size:    259 KB
  rows:    8,548

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-29 04:00:00	SPY	ETF	119.76	119.92	119.76	119.92	2600.0
2010-04-29 04:30:00	SPY	ETF	119.87	119.98	119.8	119.8	2400.0
2010-04-29 05:00:00	SPY	ETF	119.73	119.97	119.7	119.93	2200.0
2010-04-29 05:30:00	SPY	ETF	119.9	120.0	119.87	120.0	5400.0
2010-04-29 06:00:00	SPY	ETF	120.05	120.18	120.05	120.18	11241.0
2010-04-29 06:30:00	SPY	ETF	120.15	120.19	120.05	120.14	16350.0
2010-04-29 07:00:00	SPY	ETF	120.1	120.16	120.01	120.03	151000.0
2010-04-29 07:30:00	SPY	ETF	120.03	120.17	120.03	120.15	307500.0
2010-04-29 08:00:00	SPY	ETF	120.15	120.33	120.08	120.26	1522805.0
2010-04-29 08:30:00	SPY	ETF	120.27	120.28	120.13	120.19	1660043.0
2010-04-29 09:00:00	SPY	ETF	120.18	120.25	119.95	120.09	1812980.0
2010-04-29 09:30:00	SPY	ETF	120.1	120.44	120.07	120.18	27705781.0
2010-04-29 10:00:00	SPY	ETF	120.18	120.6	120.08	120.57	17497873.0
2010-04-29 10:30:00	SPY	ETF	120.57	120.92	120.48	120.8	15669121.0
2010-04-29 11:00:00	SPY	ETF	120.8	120.85	120.46	120.7801	16442408.0
2010-04-29 11:30:00	SPY	ETF	120.78	120.9301	120.61	120.83	9876358.0
2010-04-29 12:00:00	SPY	ETF	120.84	120.95	120.69	120.7999	9454936.0
2010-04-29 12:30:00	SPY	ETF	120.79	121.06	120.72	120.88	13046749.0
2010-04-29 13:00:00	SPY	ETF	120.89	120.99	120.81	120.83	8912635.0
2010-04-29 13:30:00	SPY	ETF	120.83	121.04	120.81	121.0299	4939846.0
2010-04-29 14:00:00	SPY	ETF	121.03	121.1	120.95	121.01	8203451.0
2010-04-29 14:30:00	SPY	ETF	121.01	121.11	120.71	120.8	12072194.0
2010-04-29 15:00:00	SPY	ETF	120.8	120.89	120.64	120.861	12171030.0
2010-04-29 15:30:00	SPY	ETF	120.86	120.93	120.75	120.84	19367515.0
2010-04-29 16:00:00	SPY	ETF	120.83	121.09	120.17	121.06	10339318.0
2010-04-29 16:30:00	SPY	ETF	121.05	121.05	120.92	120.97	285011.0
2010-04-29 17:00:00	SPY	ETF	120.97	121.06	120.96	121.05	35500.0
2010-04-29 17:30:00	SPY	ETF	121.04	121.06	121.02	121.05	18232.0
2010-04-29 18:00:00	SPY	ETF	121.04	121.06	120.85	121.05	18363.0
2010-04-29 18:30:00	SPY	ETF	121.06	121.06	121.01	121.01	35805.0
2010-04-29 19:00:00	SPY	ETF	121.03	121.03	120.92	120.94	62975.0
2010-04-29 19:30:00	SPY	ETF	120.94	120.94	120.79	120.8	59056.0
2010-04-29 04:00:00	QQQ	ETF	49.55	49.55	49.55	49.55	500.0
2010-04-29 05:00:00	QQQ	ETF	49.49	49.49	49.49	49.49	1000.0
2010-04-29 05:30:00	QQQ	ETF	49.58	49.58	49.58	49.58	100.0
2010-04-29 06:00:00	QQQ	ETF	49.57	49.64	49.57	49.64	6103.0
2010-04-29 06:30:00	QQQ	ETF	49.64	49.64	49.61	49.62	7880.0
2010-04-29 07:00:00	QQQ	ETF	49.63	49.64	49.6	49.62	26963.0
2010-04-29 07:30:00	QQQ	ETF	49.63	49.67	49.63	49.65	18471.0
2010-04-29 08:00:00	QQQ	ETF	49.65	49.74	49.63	49.71	347767.0
2010-04-29 08:30:00	QQQ	ETF	49.72	49.73	49.65	49.7	895560.0
2010-04-29 09:00:00	QQQ	ETF	49.7	49.73	49.61	49.61	653996.0
2010-04-29 09:30:00	QQQ	ETF	49.61	49.86	49.61	49.79	10061402.0
2010-04-29 10:00:00	QQQ	ETF	49.785	49.95	49.72	49.91	10783494.0
2010-04-29 10:30:00	QQQ	ETF	49.92	50.08	49.91	50.03	7173999.0
2010-04-29 11:00:00	QQQ	ETF	50.03	50.08	49.95	50.07	6805796.0
2010-04-29 11:30:00	QQQ	ETF	50.075	50.18	50.02	50.1401	4092641.0
2010-04-29 12:00:00	QQQ	ETF	50.145	50.19	50.1	50.15	2785878.0
2010-04-29 12:30:00	QQQ	ETF	50.16	50.29	50.13	50.2681	4334550.0
2010-04-29 13:00:00	QQQ	ETF	50.265	50.33	50.21	50.22	2947385.0

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

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