PREVIEW / etf_30min / 2009-07-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-09.parquet
  size:    216 KB
  rows:    7,179

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-09 04:00:00	SPY	ETF	88.52	88.54	88.52	88.53	1000.0
2009-07-09 04:30:00	SPY	ETF	88.55	88.63	88.55	88.62	800.0
2009-07-09 05:00:00	SPY	ETF	88.56	88.57	88.56	88.57	1000.0
2009-07-09 05:30:00	SPY	ETF	88.62	88.75	88.61	88.74	45825.0
2009-07-09 06:00:00	SPY	ETF	88.7	88.75	88.61	88.62	21200.0
2009-07-09 06:30:00	SPY	ETF	88.59	88.6	88.53	88.53	98900.0
2009-07-09 07:00:00	SPY	ETF	88.52	88.55	88.36	88.41	170963.0
2009-07-09 07:30:00	SPY	ETF	88.42	88.59	88.38	88.57	189476.0
2009-07-09 08:00:00	SPY	ETF	88.57	88.63	88.3	88.53	2566028.0
2009-07-09 08:30:00	SPY	ETF	88.61	88.9	88.53	88.72	3815774.0
2009-07-09 09:00:00	SPY	ETF	88.71	88.72	88.57	88.61	2044710.0
2009-07-09 09:30:00	SPY	ETF	88.61	88.7	88.03	88.26	20708816.0
2009-07-09 10:00:00	SPY	ETF	88.27	88.57	88.0	88.17	18270331.0
2009-07-09 10:30:00	SPY	ETF	88.18	88.45	88.01	88.34	11208657.0
2009-07-09 11:00:00	SPY	ETF	88.33	88.35	87.91	88.18	12676149.0
2009-07-09 11:30:00	SPY	ETF	88.17	88.59	88.05	88.34	8517177.0
2009-07-09 12:00:00	SPY	ETF	88.34	88.65	88.25	88.55	7187127.0
2009-07-09 12:30:00	SPY	ETF	88.55	88.64	88.39	88.6	5709243.0
2009-07-09 13:00:00	SPY	ETF	88.59	88.77	88.3	88.62	12107521.0
2009-07-09 13:30:00	SPY	ETF	88.63	88.72	88.45	88.6	6262989.0
2009-07-09 14:00:00	SPY	ETF	88.61	88.9	88.55	88.79	8971182.0
2009-07-09 14:30:00	SPY	ETF	88.79	88.89	88.52	88.55	6790653.0
2009-07-09 15:00:00	SPY	ETF	88.56	88.6	88.29	88.38	9543311.0
2009-07-09 15:30:00	SPY	ETF	88.38	88.52	88.14	88.23	18170077.0
2009-07-09 16:00:00	SPY	ETF	88.22	88.38	88.0416	88.34	7731792.0
2009-07-09 16:30:00	SPY	ETF	88.32	88.34	88.26	88.3	387947.0
2009-07-09 17:00:00	SPY	ETF	88.3	88.33	88.29	88.31	74747.0
2009-07-09 17:30:00	SPY	ETF	88.3	88.32	88.26	88.32	27285.0
2009-07-09 18:00:00	SPY	ETF	88.32	88.37	88.2	88.37	12144.0
2009-07-09 18:30:00	SPY	ETF	88.3	88.32	88.3	88.32	1900.0
2009-07-09 19:00:00	SPY	ETF	88.3	88.3	88.29	88.29	4890.0
2009-07-09 19:30:00	SPY	ETF	88.32	88.36	88.29	88.3	18855.0
2009-07-09 04:00:00	QQQ	ETF	34.83	34.84	34.82	34.84	1724.0
2009-07-09 04:30:00	QQQ	ETF	34.88	34.88	34.88	34.88	250.0
2009-07-09 05:00:00	QQQ	ETF	34.87	34.87	34.87	34.87	20000.0
2009-07-09 05:30:00	QQQ	ETF	34.88	34.89	34.87	34.89	650.0
2009-07-09 06:00:00	QQQ	ETF	34.87	34.91	34.87	34.91	500.0
2009-07-09 06:30:00	QQQ	ETF	34.87	34.87	34.85	34.85	200.0
2009-07-09 07:00:00	QQQ	ETF	34.85	34.85	34.79	34.81	142805.0
2009-07-09 07:30:00	QQQ	ETF	34.83	34.89	34.82	34.88	121497.0
2009-07-09 08:00:00	QQQ	ETF	34.88	34.89	34.81	34.86	354199.0
2009-07-09 08:30:00	QQQ	ETF	34.87	34.97	34.87	34.92	885106.0
2009-07-09 09:00:00	QQQ	ETF	34.92	34.95	34.8	34.83	1683163.0
2009-07-09 09:30:00	QQQ	ETF	34.84	34.94	34.65	34.76	15127480.0
2009-07-09 10:00:00	QQQ	ETF	34.75	34.88	34.66	34.73	8734774.0
2009-07-09 10:30:00	QQQ	ETF	34.7205	34.81	34.67	34.79	5447841.0
2009-07-09 11:00:00	QQQ	ETF	34.79	34.8	34.66	34.74	5545788.0
2009-07-09 11:30:00	QQQ	ETF	34.74	34.93	34.7	34.85	5500602.0
2009-07-09 12:00:00	QQQ	ETF	34.85	34.95	34.82	34.89	2673600.0
2009-07-09 12:30:00	QQQ	ETF	34.89	34.92	34.83	34.91	3233362.0

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

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