PREVIEW / etf_30min / 2010-01-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-15.parquet
  size:    244 KB
  rows:    8,182

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-01-15 04:30:00	SPY	ETF	114.98	114.98	114.98	114.98	300.0
2010-01-15 05:00:00	SPY	ETF	114.75	114.75	114.75	114.75	800.0
2010-01-15 05:30:00	SPY	ETF	114.75	114.8	114.75	114.8	3200.0
2010-01-15 06:00:00	SPY	ETF	114.66	114.68	114.65	114.68	13100.0
2010-01-15 06:30:00	SPY	ETF	114.65	114.82	114.65	114.75	33800.0
2010-01-15 07:00:00	SPY	ETF	114.6	114.66	114.21	114.49	730087.0
2010-01-15 07:30:00	SPY	ETF	114.46	114.55	114.26	114.4	1907597.0
2010-01-15 08:00:00	SPY	ETF	114.38	114.55	114.32	114.5	1296127.0
2010-01-15 08:30:00	SPY	ETF	114.55	114.68	114.42	114.52	1459959.0
2010-01-15 09:00:00	SPY	ETF	114.5	114.76	114.45	114.73	1901685.0
2010-01-15 09:30:00	SPY	ETF	114.73	114.84	114.1	114.21	24742122.0
2010-01-15 10:00:00	SPY	ETF	114.21	114.23	113.7	113.9	25303605.0
2010-01-15 10:30:00	SPY	ETF	113.89	113.92	113.57	113.76	18540000.0
2010-01-15 11:00:00	SPY	ETF	113.76	113.92	113.62	113.65	14812912.0
2010-01-15 11:30:00	SPY	ETF	113.64	113.71	113.49	113.54	9108040.0
2010-01-15 12:00:00	SPY	ETF	113.53	113.69	113.32	113.33	11464475.0
2010-01-15 12:30:00	SPY	ETF	113.325	113.44	113.2	113.37	16385873.0
2010-01-15 13:00:00	SPY	ETF	113.37	113.43	113.29	113.39	6170890.0
2010-01-15 13:30:00	SPY	ETF	113.39	113.52	113.325	113.45	8767097.0
2010-01-15 14:00:00	SPY	ETF	113.45	113.53	113.39	113.4	6555790.0
2010-01-15 14:30:00	SPY	ETF	113.405	113.43	113.3	113.39	11710491.0
2010-01-15 15:00:00	SPY	ETF	113.39	113.73	113.39	113.67	15786242.0
2010-01-15 15:30:00	SPY	ETF	113.66	113.78	113.6	113.66	21312812.0
2010-01-15 16:00:00	SPY	ETF	113.66	114.6	113.37	113.54	9302112.0
2010-01-15 16:30:00	SPY	ETF	113.53	114.9202	113.5	113.51	3811607.0
2010-01-15 17:00:00	SPY	ETF	113.5	113.59	113.49	113.58	175653.0
2010-01-15 17:30:00	SPY	ETF	113.59	113.61	113.56	113.56	230083.0
2010-01-15 18:00:00	SPY	ETF	113.56	113.56	113.54	113.55	6616.0
2010-01-15 18:30:00	SPY	ETF	113.55	113.57	113.53	113.54	8000.0
2010-01-15 19:00:00	SPY	ETF	113.56	113.56	113.54	113.54	1800.0
2010-01-15 19:30:00	SPY	ETF	113.54	113.55	113.5	113.55	13912.0
2010-01-15 04:00:00	QQQ	ETF	46.45	46.45	46.45	46.45	500.0
2010-01-15 04:30:00	QQQ	ETF	46.47	46.47	46.45	46.45	600.0
2010-01-15 05:30:00	QQQ	ETF	46.41	46.41	46.41	46.41	200.0
2010-01-15 06:30:00	QQQ	ETF	46.35	46.38	46.31	46.31	21960.0
2010-01-15 07:00:00	QQQ	ETF	46.3	46.3	46.18	46.24	59200.0
2010-01-15 07:30:00	QQQ	ETF	46.26	46.3	46.25	46.25	706179.0
2010-01-15 08:00:00	QQQ	ETF	46.28	46.36	46.26	46.36	230441.0
2010-01-15 08:30:00	QQQ	ETF	46.3	46.41	46.3	46.36	443382.0
2010-01-15 09:00:00	QQQ	ETF	46.36	46.46	46.33	46.45	1390265.0
2010-01-15 09:30:00	QQQ	ETF	46.46	46.55	46.14	46.21	22218879.0
2010-01-15 10:00:00	QQQ	ETF	46.21	46.23	45.94	46.07	15043700.0
2010-01-15 10:30:00	QQQ	ETF	46.07	46.09	45.94	46.07	9128488.0
2010-01-15 11:00:00	QQQ	ETF	46.07	46.08	45.96	45.99	5808227.0
2010-01-15 11:30:00	QQQ	ETF	45.98	46.0	45.82	45.86	5014552.0
2010-01-15 12:00:00	QQQ	ETF	45.85	45.93	45.71	45.71	4891070.0
2010-01-15 12:30:00	QQQ	ETF	45.71	45.77	45.65	45.77	7488325.0
2010-01-15 13:00:00	QQQ	ETF	45.76	45.79	45.68	45.74	4359997.0
2010-01-15 13:30:00	QQQ	ETF	45.75	45.82	45.72	45.7801	3705973.0
2010-01-15 14:00:00	QQQ	ETF	45.79	45.85	45.78	45.79	3947474.0

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

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