PREVIEW / etf_30min / 2009-10-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-13.parquet
  size:    230 KB
  rows:    7,580

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-10-13 04:00:00	SPY	ETF	107.44	107.44	107.42	107.42	6300.0
2009-10-13 04:30:00	SPY	ETF	107.54	107.54	107.54	107.54	100.0
2009-10-13 05:00:00	SPY	ETF	107.44	107.48	107.3	107.36	9044.0
2009-10-13 05:30:00	SPY	ETF	107.34	107.45	107.34	107.45	6700.0
2009-10-13 06:00:00	SPY	ETF	107.5	107.56	107.5	107.56	1500.0
2009-10-13 06:30:00	SPY	ETF	107.57	107.62	107.57	107.61	50500.0
2009-10-13 07:00:00	SPY	ETF	107.62	107.84	107.61	107.76	196161.0
2009-10-13 07:30:00	SPY	ETF	107.77	107.89	107.69	107.69	264094.0
2009-10-13 08:00:00	SPY	ETF	107.69	107.8	107.51	107.59	1121099.0
2009-10-13 08:30:00	SPY	ETF	107.6	107.65	107.42	107.43	897156.0
2009-10-13 09:00:00	SPY	ETF	107.44	107.5	107.32	107.38	1720946.0
2009-10-13 09:30:00	SPY	ETF	107.39	107.56	106.97	107.0317	24757260.0
2009-10-13 10:00:00	SPY	ETF	107.03	107.1	106.76	107.1	19336921.0
2009-10-13 10:30:00	SPY	ETF	107.1	107.2	107.0	107.15	8963375.0
2009-10-13 11:00:00	SPY	ETF	107.1551	107.18	106.96	107.13	8356833.0
2009-10-13 11:30:00	SPY	ETF	107.13	107.63	107.13	107.58	13832274.0
2009-10-13 12:00:00	SPY	ETF	107.57	107.65	107.34	107.4	9651135.0
2009-10-13 12:30:00	SPY	ETF	107.4	107.46	107.36	107.395	3949667.0
2009-10-13 13:00:00	SPY	ETF	107.39	107.7132	107.385	107.45	5287414.0
2009-10-13 13:30:00	SPY	ETF	107.46	107.48	107.27	107.43	5881367.0
2009-10-13 14:00:00	SPY	ETF	107.455	107.455	107.09	107.3	9457929.0
2009-10-13 14:30:00	SPY	ETF	107.3	107.48	107.25	107.34	6147190.0
2009-10-13 15:00:00	SPY	ETF	107.34	107.65	107.3	107.56	10066603.0
2009-10-13 15:30:00	SPY	ETF	107.56	107.58	107.3649	107.5	13248066.0
2009-10-13 16:00:00	SPY	ETF	107.52	107.98	106.88	107.79	6788097.0
2009-10-13 16:30:00	SPY	ETF	107.77	108.05	107.73	107.92	2969482.0
2009-10-13 17:00:00	SPY	ETF	107.92	108.52	107.7131	108.23	4207386.0
2009-10-13 17:30:00	SPY	ETF	108.22	108.37	108.22	108.3	129304.0
2009-10-13 18:00:00	SPY	ETF	108.3	108.35	108.18	108.21	216469.0
2009-10-13 18:30:00	SPY	ETF	108.25	108.25	108.14	108.15	23463.0
2009-10-13 19:00:00	SPY	ETF	108.12	108.17	108.1	108.17	18828.0
2009-10-13 19:30:00	SPY	ETF	108.17	108.22	108.12	108.18	15397.0
2009-10-13 05:00:00	QQQ	ETF	42.5	42.5	42.45	42.45	4000.0
2009-10-13 05:30:00	QQQ	ETF	42.5	42.5	42.5	42.5	100.0
2009-10-13 06:00:00	QQQ	ETF	42.55	42.55	42.55	42.55	1000.0
2009-10-13 06:30:00	QQQ	ETF	42.55	42.57	42.55	42.57	300.0
2009-10-13 07:00:00	QQQ	ETF	42.58	42.64	42.58	42.64	4687.0
2009-10-13 07:30:00	QQQ	ETF	42.66	42.68	42.6	42.63	71000.0
2009-10-13 08:00:00	QQQ	ETF	42.62	42.62	42.46	42.58	169629.0
2009-10-13 08:30:00	QQQ	ETF	42.59	42.61	42.52	42.54	212207.0
2009-10-13 09:00:00	QQQ	ETF	42.54	42.57	42.5	42.55	246884.0
2009-10-13 09:30:00	QQQ	ETF	42.54	42.69	42.45	42.49	10342030.0
2009-10-13 10:00:00	QQQ	ETF	42.48	42.51	42.37	42.51	7787992.0
2009-10-13 10:30:00	QQQ	ETF	42.5099	42.56	42.4	42.52	3355319.0
2009-10-13 11:00:00	QQQ	ETF	42.511	42.55	42.43	42.54	2665336.0
2009-10-13 11:30:00	QQQ	ETF	42.54	42.75	42.53	42.7097	4856071.0
2009-10-13 12:00:00	QQQ	ETF	42.71	42.74	42.6	42.605	2999872.0
2009-10-13 12:30:00	QQQ	ETF	42.61	42.618	42.57	42.6	1906291.0
2009-10-13 13:00:00	QQQ	ETF	42.59	42.62	42.55	42.59	2352699.0
2009-10-13 13:30:00	QQQ	ETF	42.58	42.6	42.52	42.5774	2708508.0

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

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